On this page 
The RESET statement resets a session variable to its default value for the client session.
Required privileges
No privileges are required to reset a session setting.
Synopsis
Parameters
| Parameter | Description |
|---|---|
session_var |
The name of the session variable. |
Example
Tip:
You can use SET .. TO DEFAULT to reset a session variable as well.> SET extra_float_digits = -10;
> SHOW extra_float_digits;
extra_float_digits
--------------------
-10
(1 row)
> SELECT random();
random
---------
0.20286
(1 row)
> RESET extra_float_digits;
> SHOW extra_float_digits;
extra_float_digits
--------------------
0
(1 row)
> SELECT random();
random
-------------------
0.561354028296755
(1 row)
Known Limitations
SET and RESET do not properly apply ROLLBACK within a transaction. For example, in the following transaction, showing the TIME ZONE variable does not return 2 as expected after the rollback:
SET TIME ZONE +2;
BEGIN;
SET TIME ZONE +3;
ROLLBACK;
SHOW TIME ZONE;
timezone
------------
3
