## Name

SHOW — show the value of a run-time parameter

## Synopsis

    SHOW name
    SHOW ALL

## Description

`SHOW` will display the current setting of run-time parameters. These variables can be set using the `SET` statement, by editing the `postgresql.conf` configuration file, through the `PGOPTIONS` environmental variable (when using libpq or a libpq-based application), or through command-line flags when starting the `postmaster`. See Section 16.4, “Run-time Configuration” for details.

## Parameters

`name`

  The name of a run-time parameter. Available parameters are documented in Section 16.4, “Run-time Configuration” and on the SET reference page. In addition, there are a few parameters that can be shown but not set:

  `SERVER_VERSION`

    Shows the server's version number.

  `SERVER_ENCODING`

    Shows the server-side character set encoding. At present, this parameter can be shown but not set, because the encoding is determined at database creation time.

  `LC_COLLATE`

    Shows the database's locale setting for collation (text ordering). At present, this parameter can be shown but not set, because the setting is determined at `initdb` time.

  `LC_CTYPE`

    Shows the database's locale setting for character classification. At present, this parameter can be shown but not set, because the setting is determined at `initdb` time.

  `IS_SUPERUSER`

    True if the current session authorization identifier has superuser privileges.

`ALL`

  Show the values of all configurations parameters.

## Notes

The function `current_setting` produces equivalent output. See Section 9.20, “System Administration Functions”.

## Examples

Show the current setting of the parameter `DateStyle`:

    SHOW DateStyle;
     DateStyle
    -----------
     ISO, MDY
    (1 row)

Show the current setting of the parameter `geqo`:

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

Show all settings:

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

## Compatibility

The `SHOW` command is a PostgreSQL extension.

## See Also

SET