aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/show.sgml
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/sgml/ref/show.sgml')
-rw-r--r--doc/src/sgml/ref/show.sgml53
1 files changed, 28 insertions, 25 deletions
diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml
index 45dd3800d75..e19a8cf0e84 100644
--- a/doc/src/sgml/ref/show.sgml
+++ b/doc/src/sgml/ref/show.sgml
@@ -18,7 +18,7 @@
<date>1998-09-24</date>
</refsynopsisdivinfo>
<synopsis>
-SHOW <replaceable class="PARAMETER">variable</replaceable>
+SHOW <replaceable class="PARAMETER">keyword</replaceable>
</synopsis>
<refsect2 id="R2-SQL-SHOW-1">
@@ -28,17 +28,15 @@ SHOW <replaceable class="PARAMETER">variable</replaceable>
<title>
Inputs
</title>
- <para>
+ <para>
<variablelist>
<varlistentry>
- <term>
- <replaceable class="PARAMETER">variable</replaceable>
- </term>
+ <term><replaceable class="PARAMETER">keyword</replaceable></term>
<listitem>
<para>
Refer to <command>SET</command> for more information on available
- variables.
+ arguments.
</para>
</listitem>
</varlistentry>
@@ -53,40 +51,40 @@ SHOW <replaceable class="PARAMETER">variable</replaceable>
<title>
Outputs
</title>
- <para>
+ <para>
<variablelist>
<varlistentry>
- <term>
- <returnvalue>NOTICE: <replaceable
- class="PARAMETER">">variab</replaceable>E> is <replaceable>value</replaceable></returnvalue>
- SHOW VARIABLE
- </term>
+ <term><computeroutput>
+NOTICE: <replaceable class="PARAMETER">variable</replaceable> is <replaceable>value</replaceable>
+SHOW VARIABLE
+ </computeroutput></term>
<listitem>
<para>
- Message returned if successfully.
+ Message returned if successful.
</para>
</listitem>
</varlistentry>
<varlistentry>
- <term>
- <returnvalue>NOTICE: Unrecognized variable <replaceable>value</replaceable></returnvalue>
- </term>
+ <term><computeroutput>
+NOTICE: Unrecognized variable <replaceable>value</replaceable>
+ </computeroutput></term>
<listitem>
<para>
Message returned if <returnvalue>value</returnvalue> does not exist.
</para>
</listitem>
</varlistentry>
-
+
<varlistentry>
- <term>
- NOTICE: Time zone is unknown
- SHOW VARIABLE
- </term>
+ <term><computeroutput>
+NOTICE: Time zone is unknown
+SHOW VARIABLE
+ </computeroutput></term>
<listitem>
<para>
- If the TZ environment variable is not set.
+ If the <envar>TZ</envar> or <envar>PGTZ</envar> environment
+ variable is not set.
</para>
</listitem>
</varlistentry>
@@ -138,12 +136,17 @@ SHOW <replaceable class="PARAMETER">variable</replaceable>
Usage
</title>
<para>
+ Show the current <literal>DateStyle</literal> setting:
+
<programlisting>
--- show DateStyle;
SHOW DateStyle;
NOTICE:DateStyle is Postgres with US (NonEuropean) conventions
+ </programlisting>
+ </para>
--- show Geqo;
+ <para>
+ Show the current genetic optimizer (<literal>geqo</literal>) setting:
+ <programlisting>
SHOW GEQO;
NOTICE:GEQO is ON
</programlisting>
@@ -183,7 +186,7 @@ sgml-indent-data:t
sgml-parent-document:nil
sgml-default-dtd-file:"../reference.ced"
sgml-exposed-tags:nil
-sgml-local-catalogs:"/usr/lib/sgml/CATALOG"
+sgml-local-catalogs:"/usr/lib/sgml/catalog"
sgml-local-ecat-files:nil
End:
-->