RESET
SQL - Language Statements
RESET
restore the value of a run-time parameter to the default value
RESET
RESET configuration_parameter
RESET ALL
Description
RESET restores run-time parameters to their
default values. RESET is an alternative
spelling for
SET configuration_parameter TO DEFAULT
Refer to for
details.
The default value is defined as the value that the parameter 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 configuration file, command-line options,
or per-database or per-user default settings. See for details.
See the SET> reference page for details on the
transaction behavior of RESET>.
Parameters
configuration_parameter
The name of a run-time parameter. See for a list.
ALL
Resets all settable run-time parameters to default values.
Examples
Set the geqo> configuration variable to its default value:
RESET geqo;
Compatibility
RESET is a PostgreSQL extension.