SHOW(7) SQL Commands SHOW(7)NAME
SHOW - show the value of a run-time parameter
SYNOPSIS
SHOW name
SHOW ALL
DESCRIPTION
SHOW will display the current setting of run-time parameters. These
variables can be set using the SET statement, by editing the post‐
gresql.conf configuration file, through the PGOPTIONS environmental
variable (when using libpq or a libpq-based application), or through
command-line flags when starting the postgres server. See in the docu‐
mentation for details.
PARAMETERS
name The name of a run-time parameter. Available parameters are docu‐
mented in in the documentation and on the SET [set(7)] reference
page. In addition, there are a few parameters that can be shown
but not set:
SERVER_VERSION
Shows the server's version number.
SERVER_ENCODING
Shows the server-side character set encoding. At present,
this parameter can be shown but not set, because the
encoding is determined at database creation time.
LC_COLLATE
Shows the database's locale setting for collation (text
ordering). At present, this parameter can be shown but
not set, because the setting is determined at database
creation time.
LC_CTYPE
Shows the database's locale setting for character classi‐
fication. At present, this parameter can be shown but not
set, because the setting is determined at database cre‐
ation time.
IS_SUPERUSER
True if the current role has superuser privileges.
ALL Show the values of all configuration parameters, with descrip‐
tions.
NOTES
The function current_setting produces equivalent output; see in the
documentation. Also, the pg_settings system view produces the same
information.
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
------
on
(1 row)
Show all settings:
SHOW ALL;
name | setting | description
--------------------------------+--------------------------------+----------------------------------------------------------------------------------------------
add_missing_from | off | Automatically adds missing table references to FROM clauses.
allow_system_table_mods | off | Allows modifications of the structure of system tables.
.
.
.
work_mem | 1024 | Sets the maximum memory to be used for query workspaces.
zero_damaged_pages | off | Continues processing past damaged page headers.
(146 rows)
COMPATIBILITY
The SHOW command is a PostgreSQL extension.
SEE ALSO
SET [set(7)], RESET [reset(7)]
SQL - Language Statements 2013-10-08 SHOW(7)