2 $Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.21 2003/08/31 17:32:24 petere Exp $
3 PostgreSQL documentation
6 <refentry id="SQL-RESET">
8 <refentrytitle id="SQL-RESET-TITLE">RESET</refentrytitle>
9 <refmiscinfo>SQL - Language Statements</refmiscinfo>
13 <refname>RESET</refname>
14 <refpurpose>restore the value of a run-time parameter to the default value</refpurpose>
17 <indexterm zone="sql-reset">
18 <primary>RESET</primary>
23 RESET <replaceable class="PARAMETER">parameter</replaceable>
31 <title>Description</title>
34 <command>RESET</command> restores run-time parameters to their
35 default values. <command>RESET</command> is an alternative
38 SET <replaceable class="parameter">parameter</replaceable> TO DEFAULT
40 Refer to <xref linkend="sql-set" endterm="sql-set-title"> for
45 The default value is defined as the value that the parameter would
46 have had, had no <command>SET</> ever been issued for it in the
47 current session. The actual source of this value might be a
48 compiled-in default, the configuration file, command-line options,
49 or per-database or per-user default settings. See <xref
50 linkend="runtime-config"> for details.
54 See the <command>SET</> reference page for details on the
55 transaction behavior of <command>RESET</>.
60 <title>Parameters</title>
64 <term><replaceable class="PARAMETER">parameter</replaceable></term>
67 The name of a run-time parameter. See <xref linkend="sql-set"
68 endterm="sql-set-title"> for a list.
74 <term><literal>ALL</literal></term>
77 Resets all settable run-time parameters to default values.
85 <title>Diagnostics</title>
88 See under the <xref linkend="sql-set" endterm="sql-set-title">.
93 <title>Examples</title>
96 Set <varname>datestyle</> to its default value:
103 Set <varname>geqo</> to its default value:
111 <title>Compatibility</title>
114 <command>RESET</command> is a <productname>PostgreSQL</productname> extension.
119 <!-- Keep this comment at the end of the file
124 sgml-minimize-attributes:nil
125 sgml-always-quote-attributes:t
128 sgml-parent-document:nil
129 sgml-default-dtd-file:"../reference.ced"
130 sgml-exposed-tags:nil
131 sgml-local-catalogs:"/usr/lib/sgml/catalog"
132 sgml-local-ecat-files:nil