This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
RESET
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 for a list.
- ALL
-
Resets all run-time parameters to default values.
Description
RESET restores run-time parameters to
their default values. Refer to SET for details. RESET
is an alternate form for
SET variable TO DEFAULT
Diagnostics
See under the SET
command.
Examples
Set DateStyle to its default value:
RESET DateStyle;
Set Geqo to its default value:
RESET GEQO;
Compatibility
RESET is a PostgreSQL extension.