Documentation → PostgreSQL 7.3

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.

PostgreSQL 7.3.21 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 settable 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 spelling for

SET variable TO DEFAULT

The default value is defined as the value that the variable would have had, had no SET ever been issued for it in the current session. The actual source of this value might be a compiled-in default, the postmaster's configuration file or command-line switches, or per-database or per-user default settings. See the Administrator's Guide for details.

See the SET manual page for details on the transaction behavior of RESET.

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