Documentation → PostgreSQL 7.0

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