Unsupported versions: 7.0 / 6.5 / 6.4

Historical version. PostgreSQL 7.0 has reached end of support. See the current manual.

SHOW

Name

SHOW — Shows run-time parameters for session

SHOW keyword

Inputs

keyword: Refer to SET for more information on available variables.

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.

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

See also SET and RESET 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

SQL92

There is no SHOW defined in SQL92.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.