SHOW

Shows the value of a system configuration parameter.

Synopsis

  1. SHOW <configuration_parameter>
  3. SHOW ALL

Description

SHOW displays the current settings of Greenplum Database system configuration parameters. You can set these parameters with the SET statement, or by editing the postgresql.conf configuration file of the Greenplum Database master. Note that some parameters viewable by SHOW are read-only — their values can be viewed but not set. See the Greenplum Database Reference Guide for details.

Parameters

configuration_parameter

The name of a system configuration parameter.

ALL

Shows the current value of all configuration parameters.

Examples

Show the current setting of the parameter search_path:

  1. SHOW search_path;

Show the current setting of all parameters:

  1. SHOW ALL;

Compatibility

SHOW is a Greenplum Database extension.

See Also

SET, RESET

Parent topic: SQL Command Reference