---
name: "reset"
section: "7"
platform: "linux"
package: "postgresql"
version: "7.4.7-6sarge6"
release: "Debian 3.1 (Sarge)"
platforms: ["linux"]
url: "https://new.carta.tech/reset/7"
---

# reset(7)

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

## NAME

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

## SYNOPSIS

```
RESET name
RESET ALL

```

## DESCRIPTION

**RESET** restores run-time parameters to their default values. **RESET** is an alternative spelling for

```
SET parameter TO DEFAULT

```

Refer to SET \[[**set**(7)](/set/7.md)\] for details.

The default value is defined as the value that the parameter 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 configuration file, command-line options, or per-database or per-user default settings. See the section called \`\`Run-time Configuration'' in the documentation for details.

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

## PARAMETERS

- *name*

  The name of a run-time parameter. See SET \[[**set**(7)](/set/7.md)\] for a list.

- **ALL**

  Resets all settable run-time parameters to default values.

## EXAMPLES

Set DATESTYLE to its default value:

```
RESET datestyle;

```

Set GEQO to its default value:

```
RESET geqo;

```

## COMPATIBILITY

**RESET** is a PostgreSQL extension.