VALUES

A DML command for computing a set of rows

VALUES is a DML command for computing a set of rows.

VALUES was added in PostgreSQL 8.2.

Change history

Examples

Basic usage example for VALUES:

postgres=# VALUES(1, 'foo'), (2, 'bar'), (3, 'baz');
 column1 | column2 
---------+---------
       1 | foo
       2 | bar
       3 | baz
(3 rows)
  • PostgreSQL documentation: VALUES

Categories

DML, SQL command

See also

SELECT