Data manipulationPostgreSQL

INSERT

INSERTUPDATEDELETE

Modify rows within transactional blocks.

Command

INSERT INTO (,) VALUES ('','') RETURNING id;

Example usage

Create, modify, or remove rows, optionally returning metadata.

INSERT INTO <table> (<column1>,<column2>) VALUES ('<value1>','<value2>') RETURNING id;

UPDATE <table> SET <column> = '<value>' WHERE id = <id>;

DELETE FROM <table> WHERE created_at < NOW() - INTERVAL '30 days';

Data manipulationUPDATEDELETEdatabasesqlpsql