1RESET(7) PostgreSQL 14.3 Documentation RESET(7)
2
3
4
6 RESET - restore the value of a run-time parameter to the default value
7
9 RESET configuration_parameter
10 RESET ALL
11
13 RESET restores run-time parameters to their default values. RESET is
14 an alternative spelling for
15
16 SET configuration_parameter TO DEFAULT
17
18 Refer to SET(7) for details.
19
20 The default value is defined as the value that the parameter would have
21 had, if no SET had ever been issued for it in the current session. The
22 actual source of this value might be a compiled-in default, the
23 configuration file, command-line options, or per-database or per-user
24 default settings. This is subtly different from defining it as “the
25 value that the parameter had at session start”, because if the value
26 came from the configuration file, it will be reset to whatever is
27 specified by the configuration file now. See Chapter 20 for details.
28
29 The transactional behavior of RESET is the same as SET: its effects
30 will be undone by transaction rollback.
31
33 configuration_parameter
34 Name of a settable run-time parameter. Available parameters are
35 documented in Chapter 20 and on the SET(7) reference page.
36
37 ALL
38 Resets all settable run-time parameters to default values.
39
41 Set the timezone configuration variable to its default value:
42
43 RESET timezone;
44
46 RESET is a PostgreSQL extension.
47
49 SET(7), SHOW(7)
50
51
52
53PostgreSQL 14.3 2022 RESET(7)