SHOW

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