PostgreSQL DML Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
Line 6: Line 6:
{{Internal|SQL_INSERT#Overview|Standard SQL <tt>INSERT</tt>}}
{{Internal|SQL_INSERT#Overview|Standard SQL <tt>INSERT</tt>}}
<syntaxhighlight lang='sql'>
<syntaxhighlight lang='sql'>
INSERT INTO TEST ("ID", "NAME") VALUES (10, 'Bob')
INSERT INTO person ("id", "name") VALUES (10, 'Bob')
</syntaxhighlight>
</syntaxhighlight>


Line 12: Line 12:
{{Internal|SQL_UPDATE#Overview|Standard SQL <tt>UPDATE</tt>}}
{{Internal|SQL_UPDATE#Overview|Standard SQL <tt>UPDATE</tt>}}
<syntaxhighlight lang='sql'>
<syntaxhighlight lang='sql'>
UPDATE TEST SET "ID"=50 WHERE "NAME"='Bob'
UPDATE person SET "id"=50 WHERE "name"='Bob'
</syntaxhighlight>
</syntaxhighlight>


Line 18: Line 18:
{{Internal|SQL_DELETE#Overview|Standard SQL <tt>DELETE</tt>}}
{{Internal|SQL_DELETE#Overview|Standard SQL <tt>DELETE</tt>}}
<syntaxhighlight lang='sql'>
<syntaxhighlight lang='sql'>
DELETE FROM TEST WHERE "ID"=10
DELETE FROM person WHERE "id"=10
</syntaxhighlight>
</syntaxhighlight>


Line 24: Line 24:
{{Internal|SQL_SELECT#Overview|Standard SQL <tt>SELECT</tt>}}
{{Internal|SQL_SELECT#Overview|Standard SQL <tt>SELECT</tt>}}
<syntaxhighlight lang='sql'>
<syntaxhighlight lang='sql'>
SELECT "ID", "NAME" FROM TEST
SELECT "id", "name" FROM person
</syntaxhighlight>
</syntaxhighlight>

Revision as of 23:26, 22 May 2024

Internal

INSERT

Standard SQL INSERT
INSERT INTO person ("id", "name") VALUES (10, 'Bob')

UPDATE

Standard SQL UPDATE
UPDATE person SET "id"=50 WHERE "name"='Bob'

DELETE

Standard SQL DELETE
DELETE FROM person WHERE "id"=10

SELECT

Standard SQL SELECT
SELECT "id", "name" FROM person
Retrieved from "https://kb.novaordis.com/index.php?title=PostgreSQL_DML_Operations&oldid=110612"