Name
SHOW
-- Shows run-time parameters for session
Synopsis
SHOW keyword
Inputs
- keyword
Refer to SET for more information on available
arguments.
Outputs
- NOTICE: variable is value
SHOW VARIABLE
Message returned if successful.
- NOTICE: Unrecognized variable value
Message returned if value does not exist.
- NOTICE: Time zone is unknown
SHOW VARIABLE
If the TZ or PGTZ environment
variable is not set.
Description
SHOW will display the current setting of a
run-time parameter during a session.
These variables can be set using the SET statement,
and
can be restored to the default values using the RESET
statement.
Parameters and values are case-insensitive.
Notes
SHOW is a Postgres
language extension.
Refer to SET/RESET
to set/reset variable values.
Usage
Show the current DateStyle setting:
SHOW DateStyle;
NOTICE:DateStyle is Postgres with US (NonEuropean) conventions
Show the current genetic optimizer (geqo) setting:
SHOW GEQO;
NOTICE:GEQO is ON
Compatibility
SQL92
There is no SHOW defined in SQL92.