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; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.