SHOW Conf

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 using SHOW are read-only. You can view but cannot set their values.

Syntax

1
2
3
4
5
6
7
8
9

SHOW 
  { 
    configuration_parameter | 
    CURRENT_SCHEMA | 
    TIME ZONE | 
   
    SESSION AUTHORIZATION | 
    ALL 
  };

Parameter Description

• configuration_parameter

  Name of a runtime parameter.

  Range: You can view them by running the SHOW ALL command.

  

  Some parameters that can be viewed by running SHOW ALL cannot be set by running SET. For example, max_datanodes.

• CURRENT_SCHEMA

  Current schema.

• TIME ZONE

  Time zone.

• SESSION AUTHORIZATION

  User identifier of the current session.

• ALL

  All runtime parameters.

Examples

Show the value of timezone.

1

SHOW timezone;

Show the current setting of the DateStyle parameter.

1

SHOW DateStyle;

Show the current settings of all parameters.

1

SHOW ALL;