PostgreSQL DML Operations

From NovaOrdis Knowledge Base
Revision as of 04:01, 14 October 2023 by Ovidiu (talk | contribs)
Jump to navigation Jump to search

Internal

INSERT

INSERT INTO TEST ("ID", "NAME") VALUES (10, 'Bob')

UPDATE

UPDATE TEST SET "ID"=50 WHERE "NAME"='Bob'

DELETE

DELETE FROM TEST WHERE "ID"=10

SELECT