RESET (session variable)

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

RESETSESSIONsession_var

Parameters

ParameterDescription
session_varThe name of the session variable.

Example

Tip:
You can use SET .. TO DEFAULT to reset a session variable as well.

  1. > SET extra_float_digits = -10;
  1. > SHOW extra_float_digits;

  1.  extra_float_digits

-10
(1 row)

  1. > SELECT random();

  1.  random

0.20286
(1 row)

  1. > RESET extra_float_digits;
  1. > SHOW extra_float_digits;

  1.  extra_float_digits

0
(1 row)

  1. > SELECT random();

  1.       random

0.561354028296755
(1 row)

See also

Was this page helpful?
YesNo