PostgreSQL DML Operations
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
INSERT INTO TEST ("ID", "NAME") VALUES (10, 'Bob')
UPDATE TEST SET "ID"=50 WHERE "NAME"='Bob'
DELETE FROM TEST WHERE "ID"=10