Contents
RESET
A utility command for setting a configuration parameter to its default value
RESET is a utility command for setting a configuration parameter to its default value.
RESET was added in PostgreSQL 6.1.
Usage
RESET ... is functionally equivalent to SET ... TO DEFAULT.
However RESET ALL will reset all parameters to their configured value.
Change history
- PostgreSQL 7.2
RESET ALLsyntax added (commit 4ee76ad8)
- PostgreSQL 6.1
- added (initial commit 4b531912)
Examples
Basic usage example for RESET:
postgres=# SET application_name = 'foo'; SET postgres=# SHOW application_name; application_name ------------------ foo (1 row) postgres=# RESET application_name; -- equivalent to SET application_name TO DEFAULT RESET postgres=# SHOW application_name; application_name ------------------ psql (1 row)
References
- PostgreSQL documentation: RESET