Shows the value of a system configuration parameter.
SHOW <configuration_parameter>
SHOW ALL
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.
Show the current setting of the parameter search_path
:
SHOW search_path;
Show the current setting of all parameters:
SHOW ALL;
SHOW
is a Greenplum Database extension.
Parent topic: SQL Command Reference