2 doc/src/sgml/ref/show.sgml
3 PostgreSQL documentation
6 <refentry id="SQL-SHOW">
8 <refentrytitle>SHOW</refentrytitle>
9 <manvolnum>7</manvolnum>
10 <refmiscinfo>SQL - Language Statements</refmiscinfo>
14 <refname>SHOW</refname>
15 <refpurpose>show the value of a run-time parameter</refpurpose>
18 <indexterm zone="sql-show">
19 <primary>SHOW</primary>
24 SHOW <replaceable class="PARAMETER">name</replaceable>
30 <title>Description</title>
33 <command>SHOW</command> will display the current setting of
34 run-time parameters. These variables can be set using the
35 <command>SET</command> statement, by editing the
36 <filename>postgresql.conf</filename> configuration file, through
37 the <envar>PGOPTIONS</envar> environmental variable (when using
38 <application>libpq</> or a <application>libpq</>-based
39 application), or through command-line flags when starting the
40 <command>postgres</command> server. See <xref
41 linkend="runtime-config"> for details.
46 <title>Parameters</title>
50 <term><replaceable class="PARAMETER">name</replaceable></term>
53 The name of a run-time parameter. Available parameters are
54 documented in <xref linkend="runtime-config"> and on the <xref
55 linkend="SQL-SET"> reference page. In
56 addition, there are a few parameters that can be shown but not
61 <term><literal>SERVER_VERSION</literal></term>
64 Shows the server's version number.
70 <term><literal>SERVER_ENCODING</literal></term>
73 Shows the server-side character set encoding. At present,
74 this parameter can be shown but not set, because the
75 encoding is determined at database creation time.
81 <term><literal>LC_COLLATE</literal></term>
84 Shows the database's locale setting for collation (text
85 ordering). At present, this parameter can be shown but not
86 set, because the setting is determined at database creation
93 <term><literal>LC_CTYPE</literal></term>
96 Shows the database's locale setting for character
97 classification. At present, this parameter can be shown but
98 not set, because the setting is determined at database creation
105 <term><literal>IS_SUPERUSER</literal></term>
108 True if the current role has superuser privileges.
112 </variablelist></para>
117 <term><literal>ALL</literal></term>
120 Show the values of all configuration parameters, with descriptions.
131 The function <function>current_setting</function> produces
132 equivalent output; see <xref linkend="functions-admin">.
134 <link linkend="view-pg-settings"><structname>pg_settings</structname></link>
135 system view produces the same information.
141 <title>Examples</title>
144 Show the current setting of the parameter <varname>DateStyle</varname>:
156 Show the current setting of the parameter <varname>geqo</varname>:
170 name | setting | description
171 -------------------------+---------+-------------------------------------------------
172 allow_system_table_mods | off | Allows modifications of the structure of ...
176 xmloption | content | Sets whether XML data in implicit parsing ...
177 zero_damaged_pages | off | Continues processing past damaged page headers.
179 </programlisting></para>
183 <title>Compatibility</title>
186 The <command>SHOW</command> command is a
187 <productname>PostgreSQL</productname> extension.
192 <title>See Also</title>
194 <simplelist type="inline">
195 <member><xref linkend="SQL-SET"></member>
196 <member><xref linkend="SQL-RESET"></member>