SHOW(7)

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 [set(7)] 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, by editing the postgresql.conf, through the PGOPTIONS environmental variable, or through a command-line flag when starting the postmaster.

Even with autocommit set to off, SHOW does not start a new transaction block. See the autocommit section of the Administrator's Guide for details.

DIAGNOSTICS

ERROR: Option 'name'
    Message returned if name does not stand for an existing parameter.

EXAMPLES

Show the current DateStyle setting:

SHOW DateStyle;
               DateStyle
---------------------------------------
 ISO with US (NonEuropean) conventions
(1 row)

Show the current genetic optimizer (geqo) setting:

SHOW GEQO;
 geqo
------
 on
(1 row)

Show all settings:

SHOW ALL;
             name              |                setting
-------------------------------+---------------------------------------
 australian_timezones          | off
 authentication_timeout        | 60
 checkpoint_segments           | 3
    .
    .
    .
 wal_debug                     | 0
 wal_sync_method               | fdatasync
(94 rows)

COMPATIBILITY

The SHOW command is a PostgreSQL extension.

SEE ALSO

The function current_setting produces equivalent output. See Miscellaneous Functions in the PostgreSQL User's Guide.