1SHOW(7) PostgreSQL 13.4 Documentation SHOW(7)
2
3
4
6 SHOW - show the value of a run-time parameter
7
9 SHOW name
10 SHOW ALL
11
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 19
18 for details.
19
21 name
22 The name of a run-time parameter. Available parameters are
23 documented in Chapter 19 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
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
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
87 The SHOW command is a PostgreSQL extension.
88
90 SET(7), RESET(7)
91
92
93
94PostgreSQL 13.4 2021 SHOW(7)