Last updated: August 27, 2026.
Use INSERT to add one or more rows. List the destination columns explicitly so the statement remains clear if the table changes.
Syntax
INSERT INTO table_name (column1, column2)
VALUES (value1, value2);Example
INSERT INTO AntiqueOwners
(OwnerID, OwnerLastName, OwnerFirstName)
VALUES
(4, 'Novitski', 'Peter');Match values to columns in the same order, rely on parameters in application code, and use INSERT ... SELECT when rows come from another query.
See the current PostgreSQL SQL reference; confirm dialect details for your own database.
