1RESET(7)                         SQL Commands                         RESET(7)
2
3
4

NAME

6       RESET - restore the value of a run-time parameter to the default value
7
8

SYNOPSIS

10       RESET configuration_parameter
11       RESET ALL
12
13

DESCRIPTION

15       RESET restores run-time parameters to their default values. RESET is an
16       alternative spelling for
17
18       SET configuration_parameter TO DEFAULT
19
20       Refer to SET [set(7)] for details.
21
22       The default value is defined as the value that the parameter would have
23       had,  if no SET had ever been issued for it in the current session. The
24       actual source of this value might be a compiled-in default, the config‐
25       uration file, command-line options, or per-database or per-user default
26       settings. This is subtly different from defining it as ``the value that
27       the  parameter  had  at session start'', because if the value came from
28       the configuration file, it will be reset to whatever  is  specified  by
29       the configuration file now.  See in the documentation for details.
30
31       The  transactional  behavior  of  RESET is the same as SET: its effects
32       will be undone by transaction rollback.
33

PARAMETERS

35       configuration_parameter
36              Name of a settable run-time parameter. Available parameters  are
37              documented  in in the documentation and on the SET [set(7)] ref‐
38              erence page.
39
40       ALL    Resets all settable run-time parameters to default values.
41

EXAMPLES

43       Set the timezone configuration variable to its default value:
44
45       RESET timezone;
46
47

COMPATIBILITY

49       RESET is a PostgreSQL extension.
50

SEE ALSO

52       SET [set(7)], SHOW [show(7)]
53
54
55
56SQL - Language Statements         2011-09-22                          RESET(7)