Description
SHOW will display the current setting of
run-time parameters. These variables can be set using the
SET statement, by editing the
edb-postgres.conf configuration file, through
the PGOPTIONS environmental variable (when using
libpq or a libpq-based
application), or through command-line flags when starting the
edb-postmaster. See Section 30.4 for details.
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 | off
wal_sync_method | fdatasync
(94 rows)