Skip to main content

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.