Provided by:
manpages-zh_1.5.2-1_all 
NAME
INSERT -
SYNOPSIS
INSERT INTO table [ ( column [, ...] ) ]
{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | query }
DESCRIPTION
INSERT
/ / NULL
INSERT query SELECT
PARAMETERS
table
column
table
DEFAULT VALUES
expression
column
DEFAULT
query
SELECT SELECT
OUTPUTS
INSERT
INSERT oid count
count count OID oid OID oid
EXAMPLES
films
INSERT INTO films VALUES
('UA502', 'Bananas', 105, '1971-07-13', 'Comedy', '82 minutes');
len NULL
INSERT INTO films (code, title, did, date_prod, kind)
VALUES ('T_601', 'Yojimbo', 106, '1961-06-16', 'Drama');
DEFAULT
INSERT INTO films VALUES
('UA502', 'Bananas', 105, DEFAULT, 'Comedy', '82 minutes');
INSERT INTO films (code, title, did, date_prod, kind)
VALUES ('T_601', 'Yojimbo', 106, DEFAULT, 'Drama');
tmp films
INSERT INTO films SELECT * FROM tmp;
-- 3x3 --
-- ()
INSERT INTO tictactoe (game, board[1:3][1:3])
VALUES (1,'{{"","",""},{},{"",""}}');
INSERT INTO tictactoe (game, board[3][3])
VALUES (2,'{}');
INSERT INTO tictactoe (game, board)
VALUES (3,'{{,,},{,,},{,,}}');
COMPATIBILITY
INSERT SQL query SELECT [select(7)]
Postgresql <laser@pgsqldb.org>