2 $PostgreSQL: pgsql/doc/src/sgml/ref/reset.sgml,v 1.29 2006/04/25 14:47:29 momjian 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">varname</replaceable>
29 <title>Description</title>
32 <command>RESET</command> restores run-time parameters to their
33 default values. <command>RESET</command> is an alternative
36 SET <replaceable class="parameter">varname</replaceable> TO DEFAULT
38 Refer to <xref linkend="sql-set" endterm="sql-set-title"> for
43 The default value is defined as the value that the parameter would
44 have had, had no <command>SET</> ever been issued for it in the
45 current session. The actual source of this value might be a
46 compiled-in default, the configuration file, command-line options,
47 or per-database or per-user default settings. See <xref
48 linkend="runtime-config"> for details.
52 See the <command>SET</> reference page for details on the
53 transaction behavior of <command>RESET</>. <command>RESET
54 CONNECTION</command> can be used to reset all aspects of
55 a session, not just parameter values.
61 <title>Parameters</title>
65 <term><replaceable class="PARAMETER">varname</replaceable></term>
68 The name of a run-time parameter. See <xref linkend="sql-set"
69 endterm="sql-set-title"> for a list.
75 <term><literal>ALL</literal></term>
78 Resets all settable run-time parameters to default values.
86 <title>Examples</title>
89 Set the <varname>geqo</> configuration variable to its default value:
97 <title>Compatibility</title>
100 <command>RESET</command> is a <productname>PostgreSQL</productname> extension.
105 <!-- Keep this comment at the end of the file
110 sgml-minimize-attributes:nil
111 sgml-always-quote-attributes:t
114 sgml-parent-document:nil
115 sgml-default-dtd-file:"../reference.ced"
116 sgml-exposed-tags:nil
117 sgml-local-catalogs:"/usr/lib/sgml/catalog"
118 sgml-local-ecat-files:nil