• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. RESET

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.

    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

    Resets all settable run-time parameters to default values.

Examples

-- Reset timezone to the default value:
RESET timezone;

-- Set all parameters to their default values:
RESET ALL;

Helpful Links

SET, SHOW