SHOW
SHOW — Show the value of a run-time parameter
Synopsis
SHOW name
SHOW ALL
Description
SHOW displays the current setting of run-time parameters.
Parameters
name
The name of a run-time parameter.
There are some parameters that can be displayed but not set:
SERVER_VERSION
Shows the server's version number.
SERVER_ENCODING
Shows the server-side character set encoding. Currently, this parameter can be displayed but not set, because the setting is determined when the database is created.
LC_COLLATE
Shows the locale setting for the database's collation (text ordering). Currently, this parameter can be displayed but not set, because the setting is determined when the database is created.
LC_CTYPE
Shows the locale setting for the database's character classification. Currently, this parameter can be displayed but not set, because the setting is determined when the database is created.
IS_SUPERUSER
True if the current role has superuser privileges.
ALL
Shows the values of all configuration parameters, with descriptions.
Notes
The function current_setting produces equivalent output. Also, the pg_settings system view produces the same information.
Examples
Display the current setting of the parameter DateStyle:
SHOW DateStyle;
DateStyle
----------------
ISO, MDY
(1 row)
Display the current setting of the parameter geqo:
SHOW geqo;
geqo
-----------
on
(1 row)
Display all settings:
SHOW ALL;
name | setting | description
-------------------------+---------+-------------------------------------------------
allow_system_table_mods | off | Allows modifications of the structure
of ...
.
.
.
xmloption | content | Sets whether XML data in implicit
parsing ...
zero_damaged_pages | off | Continues processing past damaged page
headers.
(196 rows)