PostgreSQL DML Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 8: Line 8:


=<TT>UPDATE</TT>=
=<TT>UPDATE</TT>=
<syntaxhighlight lang='sql'>
UPDATE TEST SET "ID"=50 WHERE "NAME"='Bob'
</syntaxhighlight>
=<TT>DELETE</TT>=
=<TT>DELETE</TT>=
=<TT>SELECT</TT>=
=<TT>SELECT</TT>=

Revision as of 04:00, 14 October 2023

Internal

INSERT

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

UPDATE

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

DELETE

SELECT