RESET ​

Reset the value of a configuration parameter to its default value.

RESET parameter

In this example, the reset value is the built-in default for the search_path parameter.

premdb=# show search_path;
   search_path   
-----------------
 "$user", public
(1 row)
premdb=# set search_path = 'public';
SET
premdb=# reset search_path;
RESET
premdb=# show search_path;
   search_path   
-----------------
 "$user", public
(1 row)

Reset values are subject to the rules under Precedence of Settings for Configuration Parameters. If the parameter has not been changed, it resets to its built-in default; however, this default may have been overridden globally with ALTER SYSTEM, and that value may also have been changed to a user-specific default with ALTER ROLE.

See also the SET, ALTER ROLE, ALTER SYSTEM, and SHOW commands.