Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Set isolation level

Change isolation for the current transaction.

Back to sheetBrowse commands
Sign in to save
Section: Transactions, Savepoints, and Locking

Set isolation level

sql
sql
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Transactions, Savepoints, and Locking
Begin transaction
Start an explicit transaction block.
OpenIn sheetsqlsame section
Commit transaction
Persist all changes in the current transaction.
OpenIn sheetsqlsame section
Rollback transaction
Discard all uncommitted work.
OpenIn sheetsqlsame section
Create savepoint
Mark a partial rollback point within a transaction.
OpenIn sheetsqlsame section
Rollback to savepoint
Undo work after the named savepoint while keeping the transaction open.
OpenIn sheetsqlsame section
Lock table
Acquire an explicit table lock.
OpenIn sheetsqlsame section