SHOW
SQL - Language Statements
SHOW
Shows run-time parameters for session
1999-07-20
SHOW keyword
1998-09-24
Inputs
keyword
Refer to
for more information on available variables.
1998-09-24
Outputs
NOTICE: variable is value
Message returned if successful.
NOTICE: Unrecognized variable value
Message returned if variable does not exist.
NOTICE: Time zone is unknown
If the TZ or PGTZ environment
variable is not set.
1998-09-24
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.
1998-09-24
Notes
See also
and
to manipulate variable values.
Usage
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 beginning with 11 relations
Compatibility
1998-09-24
SQL92
There is no SHOW defined in SQL92.