SHOW

Shows the value of a system configuration parameter.

Synopsis

SHOW <configuration_parameter>

SHOW ALL

Description

SHOW displays the current settings of LightDB-A Database system configuration parameters. You can set these parameters with the SET statement, or by editing the postgresql.conf configuration file of the LightDB-A Database coordinator. Note that some parameters viewable by SHOW are read-only — their values can be viewed but not set. See the LightDB-A 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 DateStyle:

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

Show the current setting of the parameter geqo:

SHOW geqo;
 geqo
------
 off
(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...
(331 rows)

Compatibility