RESET(l) SQL - Language Statements (2002-11-22) RESET(l)
NAME
RESET - restore the value of a run-time parameter to a
default value
SYNOPSIS
RESET variable
RESET ALL
INPUTS
variable
The name of a run-time parameter. See SET [set(l)] for
a list.
ALL Resets all settable run-time parameters to default
values.
DESCRIPTION
RESET restores run-time parameters to their default values.
Refer to SET [set(l)] for details. RESET is an alternate
spelling for
SET variable TO DEFAULT
The default value is defined as the value that the variable
would have had, had no SET ever been issued for it in the
current session. The actual source of this value might be a
compiled-in default, the postmaster's configuration file or
command-line switches, or per-database or per-user default
settings. See the Administrator's Guide for details.
See the SET manual page for details on the transaction
behavior of RESET.
DIAGNOSTICS
See under the SET [set(l)] command.
EXAMPLES
Set DateStyle to its default value:
RESET DateStyle;
Set geqo to its default value:
RESET GEQO;
Page 1 (printed 3/24/03)
RESET(l) SQL - Language Statements (2002-11-22) RESET(l)
COMPATIBILITY
RESET is a PostgreSQL extension.
Page 2 (printed 3/24/03)