Displays the current value of a server configuration parameter. This value may be specific to the current session if a SET command is in effect. For a list of configuration parameters, see Configuration reference.
Syntax
SHOW { parameter_name | ALL }
The following statement displays the current value of a session context variable. If the variable doesn't exist, Amazon Redshift throws an error.
SHOW variable_name
Parameters
- parameter_name
-
Displays the current value of the specified parameter.
- ALL
-
Displays the current values of all of the parameters.
- variable_name
-
Displays the current value of the specified variable.
Examples
The following example displays the value for the query_group parameter:
show query_group;
query_group
unset
(1 row)The following example displays a list of all parameters and their values:
show all;
name | setting
--------------------+--------------
datestyle | ISO, MDY
extra_float_digits | 0
query_group | unset
search_path | $user,public
statement_timeout | 0
The following example displays the current value of the specified variable.
SHOW app_context.user_id;