Provided by: manpages-zh_1.5.2-1_all bug

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>