PostgreSQL 7.3.4 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