RESET
RESET — restore the value of a runtime parameter to its default value
Synopsis
RESET configuration_parameter
RESET ALL
Description
RESET restores runtime parameters to their default values. RESET is an alternative spelling for SET configuration_parameter TO DEFAULT. See SET for details.
The default value is defined as the value the parameter would have if no SET had been issued in the current session. The actual source of this value might be a compiled-in default, a configuration file, a command-line option, or a per-database or per-user default setting. This is subtly different from defining it as "the value the parameter had at session start," because if the value comes from a configuration file, it will be reset to whatever the configuration file currently specifies.
The transaction behavior of RESET is the same as SET: its effects are undone by a transaction rollback.
Parameters
configuration_parameter
The name of a settable runtime parameter.
ALL
Reset all settable runtime parameters to their default values.
Examples
Reset the timezone configuration variable to its default value:
RESET timezone;