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 ALL
syntax 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