↑↓ select↵ open⌫ change scopeOpen 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 / 20devel
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.1 has reached end of support. See the current manual.

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.

Report a documentation issue

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