SHOW

Displays the value of the system configuration parameters.

Summary

SHOW configuration_parameter

SHOW ALL

describe

SHOW displays the current settings for the YMatrix database system configuration parameters. You can set these parameters using SET statements or by editing the postgresql.conf configuration file of the YMatrix database master. Note that some of the parameters that SHOW can view are read-only - they can be viewed but cannot be set. For more information, see the YMatrix Database Reference Guide.

Parameters

configuration_parameter

Name of system configuration parameters.

ALL

Displays the current values of all configuration parameters.

Example

Display the current settings of the parameter DateStyle:

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

Display the current settings of parameter geqo:

SHOW geqo;
geqo
------
off
(1 row)

Shows the current settings for 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