↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 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
Historical version. PostgreSQL 7.2 reached end of support in February 2007. See the current version for supported releases.
PostgreSQL 7.2.8 Documentation
Prev Next

RESET

Name

RESET -- restore the value of a run-time parameter to a default value

Synopsis

RESET variable
  

RESET ALL

Inputs

variable

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

ALL

Resets all run-time parameters to default values.

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 PostgreSQL extension.

Prev Home Next
REINDEX Up REVOKE

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.