SHOW

show the value of a run-time parameter

English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

6.4 6.5 7.0 7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

anchor: SQL-SHOW
file: sql-show.html
lang: en
name: SHOW
purpose: show the value of a run-time parameter
purpose zh: 显示一个运行时参数的值
sections same as: Unknown
slug: 18
synopsis html: SHOW <em class="replaceable"><code>name</code></em> SHOW ALL
synopsis text: SHOW name SHOW ALL

Syntax

SHOW name
SHOW ALL

Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

SHOW · Syntax 2

Definition PG 18

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 postgres server. See Chapter 19 for details.

Parameters

name

The name of a run-time parameter. Available parameters are documented in Chapter 19 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.
IS_SUPERUSER: True if the current role has superuser privileges.

ALL

Show the values of all configuration parameters, with descriptions.

Notes

The function current_setting produces equivalent output; see Section 9.28.1. Also, the pg_settings system view produces the same information.

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 |                description
-------------------------+---------+-------------------------------------------------
 allow_system_table_mods | off     | Allows modifications of the structure of ...
    .
    .
    .
 xmloption               | content | Sets whether XML data in implicit parsing ...
 zero_damaged_pages      | off     | Continues processing past damaged page headers.
(196 rows)

Compatibility

The SHOW command is a PostgreSQL extension.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:821f18f80532c508763bd328e01077171150d039d3309977e51cb6a7dcc8e6cc

Text language: en · wiki-repair-20261023:821f18f80532c508763bd328e01077171150d039d3309977e51cb6a7dcc8e6cc