This page in other versions: 9.0 / 9.1 / 9.2 / 9.3  |  Development versions: devel / 9.4  |  Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4

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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group