SHOW
Shows the value of a system configuration parameter.
Synopsis
SHOW <configuration_parameter>
SHOW ALLDescription
SHOW displays the current settings of Greengage DB system configuration parameters. You can set these parameters with the SET statement, or by editing the postgresql.conf configuration file of the Greengage DB master. Note that some parameters viewable by SHOW are read-only — their values can be viewed but not set.
Parameters
| Parameter | Description |
|---|---|
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 DateStyle parameter:
SHOW DateStyle;DateStyle ----------- ISO, MDY (1 row)
Show the current setting of the geqo parameter:
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
SHOW is a Greengage DB extension.