Name
RESET
-- Restores run-time parameters for session to default values
Synopsis
RESET variable
Inputs
- variable
Refer to
SET
for more information on available
variables.
Outputs
- RESET VARIABLE
Message returned if
variable is successfully reset
to its default value..
Description
RESET restores variables to the
default values.
Refer to
SET
for details on allowed values and defaults.
RESET is an alternate form for
SET variable = DEFAULT
Notes
RESET is a Postgres
language extension.
Use to
SET and
SHOW
to manipulate variable values.
Usage
Set DateStyle to its default value:
RESET DateStyle;
Set Geqo to its default value:
RESET GEQO;
Compatibility
SQL92
There is no RESET in SQL92.