Help Center/Data Warehouse Service/SQL Syntax Reference (8.1.3.x)/DDL Syntax/RESET
Updated on 2025-09-18 GMT+08:00
View PDF

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.

-

Examples

Reset timezone to the default value.

1
RESET timezone;

Set all parameters to their default values.

1
RESET ALL;

Helpful Links

SET, SHOW

Parent Topic: DDL Syntax