Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

6.3 KiB

Raw Permalink Blame History

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

configuration_parameter
Specifies the name of a settable run-time parameter.

Value range: Run-time parameters. You can view them by running the SHOW ALL command.

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
Resets all settable run-time parameters to default values.

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

6.3 KiB Raw Permalink Blame History