SHOW
Name
SHOW -- show the value of a run-time
parameter
Synopsis
SHOW name
SHOW ALL
Inputs
- name
-
The name of a run-time parameter. See SET for a list.
- ALL
-
Show all current session parameters.
Description
SHOW will display the current setting
of a run-time parameter. These variables can be set using the
SET statement or are determined at server
start.
Diagnostics
- ERROR: not a valid option
name: name
-
Message returned if variable does not stand for an
existing parameter.
- ERROR: permission
denied
-
You must be a superuser to be allowed to see certain
settings.
- NOTICE: Time zone is
unknown
-
If the TZ or PGTZ environment variable is not set.
Examples
Show the current DateStyle
setting:
SHOW DateStyle;
NOTICE: DateStyle is ISO with US (NonEuropean) conventions
Show the current genetic optimizer (geqo) setting:
SHOW GEQO;
NOTICE: geqo is on
Compatibility
The SHOW command is a PostgreSQL extension.
