granicus.if.org Git - postgresql/blob - doc/src/sgml/ref/reset.sgml

   1 <REFENTRY ID="SQL-RESET">
   2 <REFMETA>
   3 <REFENTRYTITLE>
   4 RESET
   5 </REFENTRYTITLE>
   6 <REFMISCINFO>SQL - Language Statements</REFMISCINFO>
   7 </REFMETA>
   8 <REFNAMEDIV>
   9 <REFNAME>
  10 RESET
  11 </REFNAME>
  12 <REFPURPOSE>
  13 Restores run-time parameters for session to default values
  14 </REFPURPOSE>
  15
  16 <REFSYNOPSISDIV>
  17 <REFSYNOPSISDIVINFO>
  18 <DATE>1998-09-24</DATE>
  19 </REFSYNOPSISDIVINFO>
  20 <SYNOPSIS>
  21 RESET <REPLACEABLE CLASS="PARAMETER">variable</REPLACEABLE>
  22 </SYNOPSIS>
  23
  24 <REFSECT2 ID="R2-SQL-RESET-1">
  25 <REFSECT2INFO>
  26 <DATE>1998-09-24</DATE>
  27 </REFSECT2INFO>
  28 <TITLE>
  29 Inputs
  30 </TITLE>
  31 <PARA>
  32
  33 <VARIABLELIST>
  34 <VARLISTENTRY>
  35 <TERM>
  36 <REPLACEABLE CLASS="PARAMETER">variable</REPLACEABLE>
  37 </TERM>
  38 <LISTITEM>
  39 <PARA>
  40           Refer to the SET statement for more information on available
  41           variables.
  42 </variablelist>
  43
  44 </REFSECT2>
  45
  46 <REFSECT2 ID="R2-SQL-RESET-2">
  47 <REFSECT2INFO>
  48 <DATE>1998-09-24</DATE>
  49 </REFSECT2INFO>
  50 <TITLE>
  51 Outputs
  52 </TITLE>
  53 <PARA>
  54
  55 <VARIABLELIST>
  56 <VARLISTENTRY>
  57 <TERM>
  58 RESET VARIABLE
  59 </TERM>
  60 <LISTITEM>
  61 <PARA>
  62           Message returned if
  63 <REPLACEABLE CLASS="PARAMETER">variable</REPLACEABLE> is successfully reset
  64 to its default value..
  65
  66 </VARIABLELIST>
  67
  68 </REFSECT2>
  69 </REFSYNOPSISDIV>
  70
  71 <REFSECT1 ID="R1-SQL-RESET-1">
  72 <REFSECT1INFO>
  73 <DATE>1998-09-24</DATE>
  74 </REFSECT1INFO>
  75 <TITLE>
  76 Description
  77 </TITLE>
  78 <PARA>
  79  <command>RESET</command> restores variables to the
  80  default values.
  81 Refer to the <command>SET</command> command for details on
  82  allowed values and defaults.
  83 <command>RESET</command> is an alternate form for
  84 <synopsis>
  85 <command>SET <replaceable class="parameter">variable</replaceable> = DEFAULT</command>
  86 </synopsis>
  87
  88 <REFSECT2 ID="R2-SQL-RESET-3">
  89 <REFSECT2INFO>
  90 <DATE>1998-09-24</DATE>
  91 </REFSECT2INFO>
  92 <TITLE>
  93 Notes
  94 </TITLE>
  95 <PARA>
  96 The RESET statement is a <productname>Postgres</productname> language extension.
  97 <para>
  98    Refer to SET/SHOW statements to set/show variable values.
  99
 100 </REFSECT2>
 101 </refsect1>
 102
 103 <REFSECT1 ID="R1-SQL-RESET-2">
 104 <TITLE>
 105 Usage
 106 </TITLE>
 107 <PARA>
 108 <ProgramListing>
 109 -- reset DateStyle to its default;
 110 RESET DateStyle;
 111 </programlisting>
 112 <programlisting>
 113 -- reset Geqo to its default;
 114 RESET GEQO;
 115 </ProgramListing>
 116
 117 </REFSECT1>
 118
 119 <REFSECT1 ID="R1-SQL-RESET-3">
 120 <TITLE>
 121 Compatibility
 122 </TITLE>
 123 <PARA>
 124
 125 <REFSECT2 ID="R2-SQL-RESET-4">
 126 <REFSECT2INFO>
 127 <DATE>1998-09-24</DATE>
 128 </REFSECT2INFO>
 129 <TITLE>
 130 SQL92
 131 </TITLE>
 132 <PARA>
 133    There is no <command>RESET</command> in <acronym>SQL92</acronym>.
 134
 135 </REFENTRY>