Learning PostgreSQL 11 - Third Edition

The INSERT statement

The INSERT statement is used to insert new data into tables in the database. Records are always inserted into only one table.

The INSERT statement has the following syntax:

INSERT INTO <table_name> [(<field_list>)]{VALUES (<expression_list>)[,...]}|{DEFAULT VALUES}|<SELECT query>;

The name of the table the records are inserted into is specified after the INSERT INTO keywords. There are two options when using the INSERT statement, which has a different syntax: to insert one or several individual records, or to insert a set of records produced by an SQL query.

To insert one or several records, the VALUES clause is used. The list of the field values of a new record to insert is specified after the VALUES keyword. Items in ...