SHOW

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;