SHOW(7) - f37

1SHOW(7)                  PostgreSQL 14.3 Documentation                 SHOW(7)
2
3
4

NAME

6       SHOW - show the value of a run-time parameter
7

SYNOPSIS

9       SHOW name
10       SHOW ALL
11

DESCRIPTION

13       SHOW will display the current setting of run-time parameters. These
14       variables can be set using the SET statement, by editing the
15       postgresql.conf configuration file, through the PGOPTIONS environmental
16       variable (when using libpq or a libpq-based application), or through
17       command-line flags when starting the postgres server. See Chapter 20
18       for details.
19

PARAMETERS

21       name
22           The name of a run-time parameter. Available parameters are
23           documented in Chapter 20 and on the SET(7) reference page. In
24           addition, there are a few parameters that can be shown but not set:
25
26           SERVER_VERSION
27               Shows the server's version number.
28
29           SERVER_ENCODING
30               Shows the server-side character set encoding. At present, this
31               parameter can be shown but not set, because the encoding is
32               determined at database creation time.
33
34           LC_COLLATE
35               Shows the database's locale setting for collation (text
36               ordering). At present, this parameter can be shown but not set,
37               because the setting is determined at database creation time.
38
39           LC_CTYPE
40               Shows the database's locale setting for character
41               classification. At present, this parameter can be shown but not
42               set, because the setting is determined at database creation
43               time.
44
45           IS_SUPERUSER
46               True if the current role has superuser privileges.
47
48       ALL
49           Show the values of all configuration parameters, with descriptions.
50

NOTES

52       The function current_setting produces equivalent output; see
53       Section 9.27.1. Also, the pg_settings system view produces the same
54       information.
55

EXAMPLES

57       Show the current setting of the parameter DateStyle:
58
59           SHOW DateStyle;
60            DateStyle
61           -----------
62            ISO, MDY
63           (1 row)
64
65       Show the current setting of the parameter geqo:
66
67           SHOW geqo;
68            geqo
69           ------
70            on
71           (1 row)
72
73       Show all settings:
74
75           SHOW ALL;
76                       name         | setting |                description
77           -------------------------+---------+-------------------------------------------------
78            allow_system_table_mods | off     | Allows modifications of the structure of ...
79               .
80               .
81               .
82            xmloption               | content | Sets whether XML data in implicit parsing ...
83            zero_damaged_pages      | off     | Continues processing past damaged page headers.
84           (196 rows)
85

COMPATIBILITY

87       The SHOW command is a PostgreSQL extension.
88