2 $Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.15 2002/09/21 18:32:54 petere Exp $
3 PostgreSQL documentation
6 <refentry id="SQL-RESET">
8 <refentrytitle id="SQL-RESET-TITLE">RESET</refentrytitle>
9 <refmiscinfo>SQL - Language Statements</refmiscinfo>
12 <refname>RESET</refname>
13 <refpurpose>restore the value of a run-time parameter to a default value</refpurpose>
17 RESET <replaceable class="PARAMETER">variable</replaceable>
23 <refsect2 id="R2-SQL-RESET-1">
28 <term><replaceable class="PARAMETER">variable</replaceable></term>
31 The name of a run-time parameter. See <xref
32 linkend="sql-set" endterm="sql-set-title"> for a list.
40 Resets all settable run-time parameters to default values.
51 <title>Description</title>
53 <command>RESET</command> restores run-time parameters to their
54 default values. Refer to
55 <xref linkend="sql-set" endterm="sql-set-title">
56 for details. <command>RESET</command> is an alternate spelling for
59 SET <replaceable class="parameter">variable</replaceable> TO DEFAULT
62 The default value is defined as the value that the variable would
63 have had, had no <command>SET</> ever been issued for it in the
64 current session. The actual source of this value might be a
65 compiled-in default, the postmaster's configuration file or command-line
66 switches, or per-database or per-user default settings. See the
67 <citetitle>Administrator's Guide</citetitle> for details.
72 <title>Diagnostics</title>
74 See under the <xref linkend="sql-set"
75 endterm="sql-set-title"> command.
80 <title>Examples</title>
82 Set <varname>DateStyle</> to its default value:
90 Set <varname>geqo</> to its default value:
99 <title>Compatibility</title>
102 <command>RESET</command> is a <productname>PostgreSQL</productname> extension.
107 <!-- Keep this comment at the end of the file
112 sgml-minimize-attributes:nil
113 sgml-always-quote-attributes:t
116 sgml-parent-document:nil
117 sgml-default-dtd-file:"../reference.ced"
118 sgml-exposed-tags:nil
119 sgml-local-catalogs:"/usr/lib/sgml/catalog"
120 sgml-local-ecat-files:nil