Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

RESET

Name

RESET -- Restores run-time parameters to default values

Synopsis

RESET variable
  

Inputs

variable

The name of a run-time parameter. See SET for a list.

Description

RESET restores run-time parameters to their default values. Refer to SET for details. RESET is an alternate form for

SET variable TO DEFAULT
   

Diagnostics

See under the SET command.

Examples

Set DateStyle to its default value:

RESET DateStyle;

Set Geqo to its default value:

   
RESET GEQO;

Compatibility

RESET is a Postgres extension.