SHOW(7) - c7

1SHOW(7)                 PostgreSQL 9.2.24 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 18,
18       Server Configuration, in the documentation for details.
19

PARAMETERS

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

NOTES

53       The function current_setting produces equivalent output; see Section
54       9.26, “System Administration Functions”, in the documentation. Also,
55       the pg_settings system view produces the same information.
56

EXAMPLES

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

COMPATIBILITY

88       The SHOW command is a PostgreSQL extension.
89