SHOW - Shows run-time parameters
SYNOPSIS
SHOW name
INPUTS
name The name of a run-time parameter. See SET [set(l)]
for a list.
DESCRIPTION
SHOW will display the current setting of a run-time param
eter. 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 cer
tain 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 = true
COMPATIBILITY
The SHOW command is a Postgres extension.
Man(1) output converted with
man2html