ALTER_EVENT_TRIGGER(7pg13)

✨ ALTER EVENT TRIGGER ✨

okay so bestie, this is the ALTER EVENT TRIGGER page from the PostgreSQL 13.23 Documentation — yes it's a 7 manpage, yes we're reading it for fun, and yes it's gonna be iconic 💅

---

🌸 NAME 🌸

ALTER_EVENT_TRIGGER — literally the move where you change the definition of an event trigger. that's it. that's the whole vibe 🎀

---

🦋 SYNOPSIS 🦋

ALTER EVENT TRIGGER name DISABLE
ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ]
ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER EVENT TRIGGER name RENAME TO new_name

look at her go 😭 four whole forms, all correct, all copied exactly, no cap ✨

---

💖 DESCRIPTION 💖

ALTER EVENT TRIGGER changes properties of an existing event trigger. that's the whole plot. you point it at a trigger that already exists and you're like "bestie, we're doing something different now" 🫶

🚨 important vibe check: you must be superuser to alter an event trigger. like, actual superuser. no shortcuts, no workarounds, no "but my friend said—". superuser. periodt 💀

---

🎀 PARAMETERS 🎀

• name — the name of an existing trigger to alter. the one you're picking out of the lineup 👑
• new_owner — the user name of the new owner of the event trigger. hand her the keys, she runs the place now 🔑
• new_name — the new name of the event trigger. rebrand era 🌈
• DISABLE/ENABLE [ REPLICA | ALWAYS ] — these forms configure the firing of event triggers. a disabled trigger is still known to the system, but is not executed when its triggering event occurs. like she's still on the group chat, she's just not replying 🙈 also go peek at session_replication_role while you're at it, it's related iykyk 💜

---

💀 COMPATIBILITY 💀

there is no ALTER EVENT TRIGGER statement in the SQL standard. none. zero. she's built different, she's a PostgreSQL original, not that we're bragging 👑✨

---

🧚 SEE ALSO 🧚

• CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7)) — for making one in the first place 🍓
• DROP EVENT TRIGGER (DROP_EVENT_TRIGGER(7)) — for when it's giving "we need to talk" 💔

---

and that's the page, bestie!! go forth and alter responsibly 🌸💅

sign-off note: this was PostgreSQL 13.23, dated 2025, and the header/footer both say ALTER EVENT TRIGGER(7) — consider them mentioned, consider us obsessed 🫶⭐