Synopsis

Inputs

All columns will be filled by NULLs or by values
specified when the table was created using DEFAULT
clauses.

expression

A valid expression or value to assign to column.

query

A valid query. Refer to the SELECT statement for a
further description of valid arguments.

Outputs

INSERT oid 1

Message returned if only one row was inserted.
oid is the numeric
OID of the inserted
row.

INSERT 0 #

Message returned if more than one rows were inserted.
# is the number of rows
inserted.

Description

INSERT allows one to insert new rows
into a table. One can insert a single row at a time or several
rows as a result of a query. The columns in the target list may
be listed in any order.

Each column not present in the target list will be inserted
using a default value, either a declared DEFAULT value or NULL.
PostgreSQL will reject the new
column if a NULL is inserted into a column declared NOT NULL.

If the expression for each column is not of the correct data
type, automatic type coercion will be attempted.

You must have insert privilege to a table in order to append
to it, as well as select privilege on any table specified in a
WHERE clause.