Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyAdvanced PostgreSQL

Basic Transaction (BEGIN / COMMIT)

SQL

BEGIN;

UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;

COMMIT;

Tested against PostgreSQL 16

Note

“Groups operations into a single atomic unit. If system crashes before COMMIT, neither update is saved.