SHOW

Shows the value of a run-time system configuration parameter.

Synopsis

SHOW <name>

SHOW ALL

Description

SHOW displays the current settings of Greenplum Database run-time system configuration parameters. You can set these parameters with the SET statement, by editing the postgresql.conf configuration file of the Greenplum Database coordinator, through the PGOPTIONS environment variable (when using libpq or a libpq-based application), or through command-line flags when starting the Greenplum server.

Parameters

name

The name of a run-time system configuration parameter.

Some parameters viewable by SHOW are read-only — you can view their values but not set them:

SERVER_VERSION
Shows the version number of the Greenplum Database server.
SERVER_ENCODING
Shows the server-side character set encoding. You can show, but not set, this parameter because the encoding is determined at database creation time.
LC_COLLATE
Shows the database's locale setting for collation (text ordering). You can show, but not set, this parameter because the setting is determined at database creation time.
LC_CTYPE
Shows the database's locale setting for character classification; You can show, but not set, this parameter because the setting is determined at database creation time.
IS_SUPERUSER
True if the current role has superuser privileges.
ALL
Shows the current value of all configuration parameters, with descriptions.

Notes

The function current_setting() produces equivalent output; see System Administration Functions in the PostgreSQL documentation. Also, the pg_settings system view produces the same information.

Examples

Show the current setting of the parameter DateStyle:

SHOW DateStyle;
 DateStyle
-----------
 ISO, MDY
(1 row)

Show the current setting of the parameter row_security:

SHOW row_security;
 row_security
--------------
 on
(1 row)

Show the current setting of all parameters:

SHOW ALL;
       name       | setting |                  description
-----------------+---------+----------------------------------------------------
 application_name | psql    | Sets the application name to be reported in sta...

 ...

 xmlbinary        | base64  | Sets how binary values are to be encoded in XML.
 xmloption        | content | Sets whether XML data in implicit parsing and s...
(473 rows)

Compatibility

The SHOW command is a Greenplum Database extension.

See Also

SET, RESET

Parent topic: SQL Commands

check-circle-line exclamation-circle-line close-line
Scroll to top icon