November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Unsupported versions: 7.0 / 6.5 / 6.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
PostgreSQL
Prev Next

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.

Prev Home Next
SET Up TRUNCATE