INSERT(7)                        SQL Commands                        INSERT(7)

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>

<?>
       <?><?><?><?><?><?><?><?><?> man <?><?><?><?><?><?><?><?>
       <?><?> man <?><?><?><?><?><?>https://github.com/man-pages-zh/manpages-
       zh

SQL - Language Statements         2003-11-02                         INSERT(7)