Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

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

Copy
SHOW { parameter_name | ALL }

Parameters

parameter_name

Displays the current value of the specified parameter.

ALL

Displays the current values of all of the parameters.

Examples

The following example displays the value for the query_group parameter:

Copy
show query_group; query_group unset (1 row)

The following example displays a list of all parameters and their values:

Copy
show all; name | setting --------------------+-------------- datestyle | ISO, MDY extra_float_digits | 0 query_group | unset search_path | $user,public statement_timeout | 0

On this page: