SHOW
Function
SHOW shows the current value of a run-time parameter.
Precautions
None
Syntax
SHOW
{
configuration_parameter |
CURRENT_SCHEMA |
TIME ZONE |
TRANSACTION ISOLATION LEVEL |
SESSION AUTHORIZATION |
ALL
};
Parameter Description
See Parameter Description in RESET.
Examples
-- Show the value of timezone.
postgres=# SHOW timezone;
-- Show all parameters.
postgres=# SHOW ALL;
Helpful Links
Feedback