RESET

Function

RESET restores run-time parameters to their default values. The default values are parameter default values complied in the postgresql.conf configuration file.

RESET is an alternative spelling for:

SET configuration_parameter TO DEFAULT

Precautions

RESET and SET have the same transaction behavior. Their impact will be rolled back.

Syntax

RESET {configuration_parameter | CURRENT_SCHEMA | TIME ZONE | TRANSACTION ISOLATION LEVEL | SESSION AUTHORIZATION | ALL };

Parameter Description

**Table 1** RESET parameters
Parameter	Description	Value Range
configuration_parameter	Specifies the name of a settable run-time parameter.	You can view run-time parameters by running the SHOW ALL command. NOTE: Some parameters that viewed by SHOW ALL cannot be set by SET. For example, max_datanodes.
CURRENT_SCHEMA	Specifies the current schema.	-
TIME ZONE	Specifies the time zone.	-
TRANSACTION ISOLATION LEVEL	Specifies the transaction isolation level.	-
SESSION AUTHORIZATION	Specifies the session authorization.	-
ALL	Specifies all runtime parameters.	-