SHOW name
SHOW ALL
The name of a run-time parameter. See SET for a list.
Show all current session parameters.
SHOW will display the current setting of a run-time parameter. These variables can be set using the SET statement, by editing the postgresql.conf, through the PGOPTIONS environmental variable, or through a command-line flag when starting the postmaster.
Even with autocommit set to off, SHOW does not start a new transaction block. See the autocommit section of the Administrator's Guide for details.
Message returned if name does not stand for an existing parameter.
Show the current DateStyle setting:
SHOW DateStyle;
DateStyle
---------------------------------------
ISO with US (NonEuropean) conventions
(1 row)
Show the current genetic optimizer (geqo) setting:
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)