SQL · Transactions and integrity

isolation levels

Controls how concurrent transactions see each other’s work. PostgreSQL defaults to READ COMMITTED.

sqlRunnable example sql course

Syntax

set transaction isolation level …

Example

Open in the lab

-- PostgreSQL
-- BEGIN ISOLATION LEVEL SERIALIZABLE;
-- COMMIT;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.