RESET

Restores the value of the system configuration parameter to the default value.

Summary

RESET configuration_parameter

RESET ALL

describe

RESET restores the system configuration parameters to their default values. RESET is an alternative writing method for SET configuration_parameter TO DEFAULT.

The default value is defined as the value that this parameter will have when it is not issued a SET for it in the current session. The actual source of this value may be the compiled default value, the main postgresql.conf configuration file, command line options, or the default settings per database or per user.

Parameters

configuration_parameter

Name of system configuration parameters.

ALL

Reset all settable configuration parameters to their default values.

Example

Set the statement_mem configuration parameter to its default value:

RESET statement_mem;

compatibility