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.

IntermediateAdvanced PostgreSQL

Transaction Rollback

SQL

BEGIN;
DELETE FROM employees; -- Oops!
ROLLBACK;

Tested against PostgreSQL 16

Note

“ROLLBACK undoes all changes made within the current transaction block. Lifesaver for manual database updates.