PostgreSQL DML Operations

Internal

• PostgreSQL Operations
• SQL Data Statements (DML)

INSERT

Standard SQL INSERT

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

Note: 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'

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