Help Center/ GaussDB/ M-Compatibility Developer Guide(Centralized)/ SQL Reference/ SQL Syntax/ SQL Statements/ R/ RESET
Updated on 2025-10-23 GMT+08:00
View PDF
Share

RESET

Description

Restores run-time parameters to their default values. The default values are parameter default values complied in the gaussdb.conf configuration file.

The current version does not support RESET configuration_parameter. Only RESET ALL is supported.

Precautions

  • RESET ALL and SET have the same transaction behavior. Their impact will be rolled back.
  • RESET ALL cannot be used to restore the default values of role and session authorization.

Syntax

RESET ALL;

Parameters

  • ALL

    Resets all settable run-time parameters to default values.

Examples

-- Set all parameters to their default values.
m_db=# RESET ALL;

Helpful Links

SET and SHOW

Parent topic: R