Insert, update, delete

Draft

Reading rows is only half of SQL. This lesson changes data with INSERT, UPDATE, and DELETE, always using RETURNING so the result is visible.

Insert a row

INSERT adds a row. RETURNING shows the row PostgreSQL stored.

INSERT INTO users (name, email)
VALUES ('Edsger Dijkstra', 'edsger@example.com')
RETURNING *;

Loading plan...

UPDATE changes matching rows. The WHERE clause keeps the change focused.

UPDATE users
SET active = false
WHERE email = 'alan@example.com'
RETURNING *;

Loading plan...

DELETE removes matching rows. RETURNING is useful when you want to inspect what was removed.

DELETE FROM users
WHERE email = 'grace@example.com'
RETURNING *;

Loading plan...