The SHOW ALL statement lists all current run-time settings.

Required Privileges

No privileges are required to list all current run-time settings.

Synopsis

SHOW ALL

Response

The following run-time variables are returned by SHOW ALL:

Variable Description
DATABASE The default database for the current session, as set by SET DATABASE or the client’s connection string. This variable can be viewed with SHOW DATABASE as well.
DEFAULT_TRANSACTION_ISOLATION The default transaction isolation level for the current session, as set by SET DEFAULT_TRANSACTION_ISOLATION or the client’s connection string.
SYNTAX The default SQL syntax for the current session, as set by SET SYNTAX. This variable can be viewed with SHOW SYNTAX as well.
TIME ZONE The default time zone for the current session, as set by SET TIME ZONE. This variable can be viewed with SHOW TIME ZONE as well.
TRANSACTION ISOLATION LEVEL The isolation level of the current transaction, as set by SET TRANSACTION ISOLATION LEVEL. When run in the context of a transaction, SHOW TRANSACTION ISOLATION LEVEL returns this variable as well.

This will differ from DEFAULT_TRANSACTION_ISOLATION only when SHOW ALL is run in the context of a transaction and SET TRANSACTION ISOLATION LEVEL has been used to set a non-default isolation level for the specific transaction.
TRANSACTION PRIORITY The priority of the current transaction, as set by SET TRANSACTION PRIORITY. When run in the context of a transaction, SHOW TRANSACTION PRIORITY returns this variable as well.

Example

> SHOW ALL;
+-------------------------------+--------------+
|           Variable            |    Value     |
+-------------------------------+--------------+
| DATABASE                      | bank         |
| DEFAULT_TRANSACTION_ISOLATION | SERIALIZABLE |
| SYNTAX                        | Traditional  |
| TIME ZONE                     | UTC          |
| TRANSACTION ISOLATION LEVEL   | SERIALIZABLE |
| TRANSACTION PRIORITY          | NORMAL       |
+-------------------------------+--------------+
(6 rows)

See Also



Yes No