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.

Synopsis

Parameters

Parameter	Description
session\_var	The name of the .

Example

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)

Known Limitations

and RESET do not properly apply within a transaction. For example, in the following transaction, showing the TIME ZONE does not return 2 as expected after the rollback:

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

timezone
------------
3

See also