Displays the current transaction isolation level : Transaction Isolation « Transaction « PostgreSQL






  1. PostgreSQL
  2. Transaction
  3. Transaction Isolation

Displays the current transaction isolation level


postgres=# -- Displays the current transaction isolation level:
postgres=#
postgres=# SHOW TRANSACTION ISOLATION LEVEL;
 transaction_isolation
-----------------------
 read committed
(1 row)

postgres=#
postgres=#








Related examples in the same category

1.Sets the transaction isolation level to SERIALIZABLE for the current transaction
2.Set the default transaction isolation level for the current session
3.Sets the constraint evaluation mode to IMMEDIATE for all constraints within the transaction