RESET (session variable)

2020-02-16

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

{% include {{ page.version.version }}/sql/diagrams/reset_session.html %}

Parameters

Parameter Description
session_var The name of the session variable.

Example

{{site.data.alerts.callout_success}}You can use SET .. TO DEFAULT to reset a session variable as well.{{site.data.alerts.end}}

> 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)

See also