RESET
Restores a runtime system configuration parameter to the default value.
Syntax
RESET <config_param>
RESET ALL
Description
RESET
is an equivalent to SET <config_param> TO DEFAULT
. The effects of RESET
in a transaction will be restored if the transaction is rolled back. This is also the same as SET
. For more details, see SET.
A default value of a parameter is the value that will be automatically assigned to the parameter if the parameter has no value SET
for it in the current session. Such a value can be sourced from the compiled-in default, the postgresql.conf
configuration file, the command-line options, or the per-database or per-user default settings.
Parameters
<config_param>
: the name of the runtime system configuration parameter. If you want to reset all system configuration parameters, set this parameter to ALL
.
Examples
Reset statement_mem
to its default value:
RESET statement_mem;
SQL standard compatibility
RESET
is a Relyt extension.