12th September 2019: PostgreSQL 12 Beta 4 Released!
Supported Versions: Current (11) / 10 / 9.6 / 9.5 / 9.4
Development Versions: 12 / devel
Unsupported versions: 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
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 supported versions listed above instead.

SHOW

Name

SHOW -- Shows run-time parameters

Synopsis

SHOW name
  

Inputs

name

The name of a run-time parameter. See SET for a list.

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 = true

Compatibility

The SHOW command is a Postgres extension.