RESET(7)

✨ RESET 💅

okay bestie, pull up a chair, because this one is short but it's lowkey important. this is the RESET page from the PostgreSQL 18.6 docs, and it's giving "small but mighty." 🎀

NAME 🌸

RESET — restore the value of a run-time parameter to the default value. periodt. 🫶

SYNOPSIS ✨

RESET configuration_parameter
RESET ALL

that's it. two whole lines. iconic behavior honestly. 💖

DESCRIPTION 🦋

okay so, RESET restores run-time parameters to their default values. and here's the tea: RESET is literally just an alternative spelling for

SET configuration_parameter TO DEFAULT

so if you already know SET, you already know this. go peek at SET(7) for the deets. 👑

now, what even is "the default value"? bestie, listen, this part matters. the default value is defined as the value that the parameter would have had if no SET had ever been issued for it in the current session. and the actual source of that value might be:

a compiled-in default
the configuration file
command-line options
per-database or per-user default settings

any of those. 💫

and here's the ✨subtle✨ thing that trips people up: this is not quite the same as defining it as "the value that the parameter had at session start." why? because if the value came from the configuration file, it will be reset to whatever is specified by the configuration file now. like, right now, as you're reading this. so if someone edited the config file mid-session, congrats, you get the new vibe. 🌀

see Chapter 19 for details.

and the transactional behavior of RESET is the same as SET: its effects will be undone by transaction rollback. so if you roll back, everything goes back to how it was. no cap. 🫡

PARAMETERS 🎀

configuration_parameter — name of a settable run-time parameter. the available parameters are documented in Chapter 19 and on the SET(7) reference page. go look if you're curious, there's a lot of them bestie 😭
ALL — resets all settable run-time parameters to default values. all of them. every single one. the whole roster. 🔥

EXAMPLES 💜

set the timezone configuration variable to its default value:

RESET timezone;

boom. one line. slay. 💅

COMPATIBILITY 🌈

RESET is a PostgreSQL extension. iykyk, it's a house specialty, not a standard thing. 💀