Help Center > > Developer Guide> SQL Reference> SQL Syntax> RESET

RESET

Updated at: Mar 13, 2020 GMT+08:00

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

1
2
3
4
5
-- Reset timezone to the default value:
RESET timezone;

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

Helpful Links

SET, SHOW

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel