RESET {session variable}

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.

Parameter	Description
`session_var`	The name of the session variable.

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)

SET and RESET do not properly apply ROLLBACK 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