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

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)
  • PostgreSQL documentation: RESET

Categories

SQL command, Utility command

See also

SET, SHOW