<REFENTRY ID="SQL-RESET"> <REFMETA> <REFENTRYTITLE> RESET </REFENTRYTITLE> <REFMISCINFO>SQL - Language Statements</REFMISCINFO> </REFMETA> <REFNAMEDIV> <REFNAME> RESET </REFNAME> <REFPURPOSE> Restores run-time parameters for session to default values </REFPURPOSE> <REFSYNOPSISDIV> <REFSYNOPSISDIVINFO> <DATE>1998-09-01</DATE> </REFSYNOPSISDIVINFO> <SYNOPSIS> RESET <REPLACEABLE CLASS="PARAMETER">variable</REPLACEABLE> </SYNOPSIS> <REFSECT2 ID="R2-SQL-RESET-1"> <REFSECT2INFO> <DATE>1998-09-01</DATE> </REFSECT2INFO> <TITLE> Inputs </TITLE> <PARA> </PARA> <VARIABLELIST> <VARLISTENTRY> <TERM> <REPLACEABLE CLASS="PARAMETER">variable</REPLACEABLE> </TERM> <LISTITEM> <PARA> Refer to the SET statement for more information on available variables. </variablelist> </REFSECT2> <REFSECT2 ID="R2-SQL-RESET-2"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> Outputs </TITLE> <PARA> </PARA> <VARIABLELIST> <VARLISTENTRY> <TERM> RESET VARIABLE </TERM> <LISTITEM> <PARA> Message returned if successfully. </VARIABLELIST> </REFSECT2> </REFSYNOPSISDIV> <REFSECT1 ID="R1-SQL-RESET-1"> <REFSECT1INFO> <DATE>1998-04-15</DATE> </REFSECT1INFO> <TITLE> Description </TITLE> <PARA> The RESET statement restores variables to the default values. Refer to the SET command for details on allowed values and defaults. RESET is an alternate form for <synopsis> <command>SET <replaceable class="parameter">variable</replaceable> = DEFAULT</command> </synopsis> <REFSECT2 ID="R2-SQL-RESET-3"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> Notes </TITLE> <PARA> The RESET statement is a <productname>Postgres</productname> language extension. <para> Refer to SET/SHOW statements to set/show variable values. </REFSECT2> </refsect1> <REFSECT1 ID="R1-SQL-RESET-2"> <TITLE> Usage </TITLE> <PARA> <ProgramListing> -- reset DateStyle to its default; RESET DateStyle; </programlisting> <programlisting> -- reset Geqo to its default; RESET GEQO; </ProgramListing> </REFSECT1> <REFSECT1 ID="R1-SQL-RESET-3"> <TITLE> Compatibility </TITLE> <PARA> </PARA> <REFSECT2 ID="R2-SQL-RESET-4"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> SQL92 </TITLE> <PARA> There is no RESET statement in SQL92. </REFENTRY> <!-- <REPLACEABLE CLASS="PARAMETER"> </REPLACEABLE> <ReturnValue></ReturnValue> <PARA> </PARA> <VARIABLELIST> <VARLISTENTRY> <TERM>• </TERM> <LISTITEM> <PARA> </PARA> </LISTITEM> </VARLISTENTRY> </VARIABLELIST> <PARA> </PARA> -->