Skip to main content

SHOW

Shows the value of a runtime configuration parameter or the values of all runtime configuration parameters.

Syntax​

SHOW <name>

SHOW ALL

Description​

You can use SHOW to check current settings of runtime configuration parameters that can be set by SET, by editing the postgresql.conf configuration file, or through the PGOPTIONS environment variable.

info

You can use function current_setting() (see System Administration Functions in the PostgreSQL documentation for details) or system view pg_setting as an alternative of SHOW.

Parameters​

  • <name>

    The name of the runtime configuration parameter.

  • ALL

    You can run SHOW ALL to display the values of all runtime configuration parameters.

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)

SQL standard compatibility​

SHOW is a Relyt extension.