On this page
Warning:
As of May 10, 2022, CockroachDB v20.2 is no longer supported. For more details, refer to the Release Support Policy.
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](set-vars.html#supported-variables).
## 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)