SHOW will display the current setting of run-time parameters. These variables can be set using the SET statement, by editing the postgresql.conf configuration file, through the PGOPTIONS environmental variable (when using libpq or a libpq-based application), or through command-line flags when starting the postmaster. See Section 16.4 for details.
Parameters
name
The name of a run-time parameter. Available parameters are documented in Section 16.4 and on the SET 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 initdb time.
LC_CTYPE
Shows the database's locale setting for character classification. At present, this parameter can be shown but not set, because the setting is determined at initdb time.
IS_SUPERUSER
True if the current session authorization identifier has superuser privileges.
ALL
Show the values of all configurations parameters.
Notes
The function current_setting produces equivalent output. See Section 9.13.
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 -------------------------------+--------------------------------------- australian_timezones | off authentication_timeout | 60 checkpoint_segments | 3 . . . wal_debug | 0 wal_sync_method | fdatasync (94 rows)
Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
Free Sample Chapters