Documentation → PostgreSQL 6.4

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 variable

Inputs

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

Outputs

NOTICE: variable is value SHOW VARIABLE: Message returned if successfully.
NOTICE: Unrecognized variable value: Message returned if value does not exist.
NOTICE: Time zone is unknown SHOW VARIABLE: If the TZ environment variable is not set.

Description

SHOW will display the current configuration parameters for variable during a session.

The session can be configured using SET statement, and values can be restored to the defaults using RESET statement. Parameters and values are case-insensitive.

Notes

The SHOW is a Postgres language extension.

Refer to SET/RESET to set/reset variable values. See also SET TIME ZONE.

Usage

-- show DateStyle;
SHOW DateStyle;
NOTICE:DateStyle is Postgres with US (NonEuropean) conventions

-- show Geqo;
SHOW GEQO;
NOTICE:GEQO is ON

Compatibility

SQL92

There is no SET defined in SQL92.

Prev	Home	Next
SET	Up	UNLISTEN