SHOW

    Description

    displays the current settings of Greenplum Database system configuration parameters. You can set these parameters with the SET statement, or by editing the 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.

    configuration_parameter

    ALL

    Shows the current value of all configuration parameters.

    Examples

    Show the current setting of all parameters:

    SHOW is a Greenplum Database extension.

    See Also

    Parent topic: SQL Command Reference