<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.7 1999/07/22 15:09:14 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.8 2000/04/08 02:39:02 tgl Exp $

Postgres documentation

-->

<para>

Refer to

<xref linkend="sql-set-title" endterm="sql-set-title">

for more information on available

variables.

for more information on available variables.

</para>

</listitem>

</varlistentry>

<para>

Message returned if

<replaceable class="PARAMETER">variable</replaceable> is successfully reset

to its default value..

to its default value.

</para>

</listitem>

</varlistentry>

Description

</title>

<para>

<command>RESET</command> restores variables tothe

<command>RESET</command> restores variables totheir

default values.

Refer to

<xref linkend="sql-set-title" endterm="sql-set-title">

</title>

<para>

<command>RESET</command> is a <productname>Postgres</productname>

language extension.

</para>

<para>

Use to

See also

<xref linkend="sql-set-title" endterm="sql-set-title"> and

<xref linkend="sql-show-title" endterm="sql-show-title">

to manipulate variable values.

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/show.sgml,v 1.8 2000/02/15 20:49:07 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/show.sgml,v 1.9 2000/04/08 02:39:02 tgl Exp $

Postgres documentation

-->

<term><replaceable class="PARAMETER">keyword</replaceable></term>

<listitem>

<para>

Refer to <command>SET</command> for more information on available

arguments.

Refer to

<xref linkend="sql-set-title" endterm="sql-set-title">

for more information on available variables.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>

NOTICE: <replaceable class="PARAMETER">variable</replaceable> is <replaceable>value</replaceable>

SHOW VARIABLE

</computeroutput></term>

<listitem>

<para>

</computeroutput></term>

<listitem>

<para>

Message returned if <returnvalue>value</returnvalue> does not exist.

Message returned if <returnvalue>variable</returnvalue> does not exist.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>

NOTICE: Time zone is unknown

SHOW VARIABLE

</computeroutput></term>

<listitem>

<para>

Notes

</title>

<para>

<command>SHOW</command> is a <productname>Postgres</productname>

language extension.

</para>

<para>

Refer to <command>SET</command>/<command>RESET</command>

to set/reset variable values.

See also

<xref linkend="sql-set-title" endterm="sql-set-title"> and

<xref linkend="sql-reset-title" endterm="sql-reset-title">

to manipulate variable values.

</para>

</refsect2>

</refsect1>

<programlisting>

SHOW DateStyle;

NOTICE:DateStyle isPostgres with US (NonEuropean) conventions

NOTICE:DateStyle isISO with US (NonEuropean) conventions

</programlisting>

</para>

<para>

Show the current genetic optimizer (<literal>geqo</literal>) setting:

<programlisting>

SHOW GEQO;

NOTICE:GEQO is ON

NOTICE:GEQO is ON beginning with 11 relations

</programlisting>

</para>

</refsect1>