RESET(7)

✨ RESET(7) ✨

okay bestie, so this is the RESET page from the PostgreSQL 16.15 Documentation — yes the whole manual, and yes we're doing this together, buckle up 🎀

---

🌸 NAME 🌸

RESET — puts a run-time parameter back to its default value, like hitting undo on your settings ✨

---

🦋 SYNOPSIS 🦋

RESET configuration_parameter
RESET ALL

---

💜 DESCRIPTION 💜

So RESET restores run-time parameters to their default values. That's the whole vibe. 💅

And lowkey, RESET is literally just an alternative spelling for:

SET configuration_parameter TO DEFAULT

so if you already read SET(7) you're kind of already an expert — go look at it for the details, iykyk.

Now here's the part that's giving subtle and you gotta pay attention: the default value is defined as the value the parameter would have had if no SET had ever been issued for it in the current session. The actual source of that value might be a compiled-in default, the configuration file, command-line options, or per-database or per-user default settings. So many possibilities, honestly iconic 🌈

And this is subtly different from defining it as "the value that the parameter had at session start" — and the reason is lowkey genius: if the value came from the configuration file, it'll be reset to whatever is specified by the configuration file now. Like, now now. Present tense. Chapter 20 has the details if you're obsessed (you should be).

The transactional behavior of RESET is the same as SET: its effects will be undone by transaction rollback. fr fr, roll it back and it's like it never happened 😭

---

🫶 PARAMETERS 🫶

• configuration_parameter — the name of a settable run-time parameter. All the available parameters are documented in Chapter 20 and on the SET(7) reference page 💖
• ALL — resets all settable run-time parameters to their default values. everyone gets a fresh start, we love a clean slate ✨

---

🍓 EXAMPLES 🍓

Set the timezone configuration variable to its default value:

RESET timezone;

that's it. that's the example. and it ate 🔥

---

💀 COMPATIBILITY 💀

RESET is a PostgreSQL extension. it's our thing, not standard SQL's thing — you're welcome 👑

---

⭐ SEE ALSO ⭐

• SET(7)
• SHOW(7)

go read those too, bestie, they're the rest of the trio 🧚

---

and that's a wrap! 💖 this lil masterpiece comes to you from PostgreSQL 16.15, dated 2026 — RESET(7), page closed, slay 🎀✨