RESET(7)

💅 RESET(7) — the PostgreSQL glow-up for your settings ✨

okay bestie, so this is RESET from the PostgreSQL 17.11 docs, and honestly? it's the "undo" button your run-time parameters have been waiting for. let's get into it 🫶

---

🌸 NAME 🌸

RESET — restores the value of a run-time parameter to the default value. it's giving factory settings reset, but make it database 💅

---

✨ SYNOPSIS ✨

RESET configuration_parameter
RESET ALL

two ways to do the thing. pick your fighter 🎀

---

🦋 DESCRIPTION 🦋

so RESET restores run-time parameters to their default values. and lowkey, RESET is just an alternative spelling for:

SET configuration_parameter TO DEFAULT

like, same energy, different outfit. refer to SET(7) for details, bestie, that's where the deep lore lives 📖

now here's the part where you need to listen: 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. the actual source of this value might be any of these cuties:

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

and this is subtly different from defining it as "the value that the parameter had at session start" 👀 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-now. not at session start. see Chapter 19 for details, iykyk 📚

the transactional behavior of RESET is the same as SET: its effects will be undone by transaction rollback. so if you roll back, it's like it never happened. no evidence, no receipts, nothing 💀

---

🎀 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 check those, they're iconic 👑
• ALL — resets all settable run-time parameters to default values. yes, all of them. the whole roster. main character move fr fr 🔥

---

💖 EXAMPLES 💖

set the timezone configuration variable to its default value:

RESET timezone;

that's it. that's the example. slay ✨

---

🌈 COMPATIBILITY 🌈

RESET is a PostgreSQL extension. so if you're out here expecting other databases to know what this is… ngl, they don't 🙈 it's a PostgreSQL thing, and it's ours 💜

---

👑 SEE ALSO 👑

• SET(7)
• SHOW(7)

go read those too, bestie, they're literally the sibling pages 🫶

---

ngl the one thing to keep in your notes app: RESET doesn't rewind to "session start" — it snaps back to whatever the default is right now, config file included. don't let anyone tell you otherwise 💅

---

and that's the whole page! brought to you by PostgreSQL 17.11, dated 2026 — see you in the next manual page, mwah 🍓🧚⭐