Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

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

SHOW

Name

SHOW -- show the value of a run-time parameter

Synopsis

SHOW name

SHOW ALL

Inputs

name: The name of a run-time parameter. See SET for a list.
ALL: Show all current session parameters.

Description

SHOW will display the current setting of a run-time parameter. These variables can be set using the SET statement or are determined at server start.

Diagnostics

ERROR: not a valid option name: name: Message returned if variable does not stand for an existing parameter.
ERROR: permission denied: You must be a superuser to be allowed to see certain settings.
NOTICE: Time zone is unknown: If the TZ or PGTZ environment variable is not set.

Examples

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

Compatibility

The SHOW command is a PostgreSQL extension.

Report a documentation issue

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