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)