RESET {session variable}

The RESET resets a to its default value for the client session.

Required privileges

No are required to reset a session setting.

Parameter	Description
`session\_var`	The name of the .

You can use 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)

and RESET do not properly apply within a transaction. For example:

SET TIME ZONE +2;
BEGIN;
SET TIME ZONE +3;
ROLLBACK;
SHOW TIME ZONE;

  timezone
------------
  <+03>-03

SET TIME ZONE +2;
BEGIN;
RESET TIME ZONE;
ROLLBACK;
SHOW TIME ZONE;

  timezone
------------
  UTC