PostgreSQL DML Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
 
(4 intermediate revisions by the same user not shown)
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>
Double quotes can be used around column names.
Use single quotes for the string values. Double quotes will let the SQL interpreter think you use a column name.


=<TT>UPDATE</TT>=
=<TT>UPDATE</TT>=
{{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>
Double quotes can be used around column names.


=<TT>DELETE</TT>=
=<TT>DELETE</TT>=
{{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>
Double quotes can be used around column names.


=<TT>SELECT</TT>=
=<TT>SELECT</TT>=
{{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>

Latest revision as of 19:32, 24 May 2024

Internal

INSERT

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

Double quotes can be used around column names.

Use single quotes for the string values. Double quotes will let the SQL interpreter think you use a column name.

UPDATE

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

Double quotes can be used around column names.

DELETE

Standard SQL DELETE
DELETE FROM person WHERE id=10

Double quotes can be used around column names.

SELECT

Standard SQL SELECT
SELECT "id", "name" FROM person