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
Parameters
Parameter | Description |
---|---|
session_var | The name of the session variable. |
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
extra_float_digits
-10
(1 row)
> SELECT random();
random
random
0.20286
(1 row)
> RESET extra_float_digits;
> SHOW extra_float_digits;
extra_float_digits
extra_float_digits
0
(1 row)
> SELECT random();
random
random
0.561354028296755
(1 row)
See also
当前内容版权归 cockroachlabs.com 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 cockroachlabs.com .