SHOW¶
Function¶
Shows the current value of a runtime parameter. You can use the SET statement to set these parameters.
Precautions¶
Some parameters that can be viewed by running the SHOW command are read-only. You can view but cannot modify their values.
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.
SHOW timezone;
Show the current setting of the DateStyle parameter.
SHOW DateStyle;
Show the current setting of all parameters.
SHOW ALL;