ALTER_EVENT_TRIGGER(7pg18)

💖 ALTER EVENT TRIGGER 💖

okay bestie, so this one lives in the PostgreSQL 18.6 Documentation and it's called ALTER_EVENT_TRIGGER — yes the manual page name has underscores, that's just how the docs do, iykyk. It's all about changing the definition of an event trigger. Let's get into it 🎀

---

✨ NAME ✨

ALTER_EVENT_TRIGGER — change the definition of an event trigger

---

🌸 SYNOPSIS 🌸

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

---

🦋 DESCRIPTION 🦋

So ALTER EVENT TRIGGER changes properties of an existing event trigger. That's it, that's the whole job. Lowkey iconic for how simple it is 💅

🚨 but listen. You must be superuser to alter an event trigger. No superuser, no vibes. Periodt.

---

👑 PARAMETERS 👑

• name — the name of an existing trigger to alter. Gotta name it, bestie, we can't just point at vibes.
• new_owner — the user name of the new owner of the event trigger. Handing over the keys 🔑
• new_name — the new name of the event trigger. Glow-up via rename, slay.
• 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, it's still in the group chat, it's just on mute 🔇. See also session_replication_role.

---

🌈 COMPATIBILITY 🌈

ngl there is no ALTER EVENT TRIGGER statement in the SQL standard. fr fr. It's a PostgreSQL original, main character energy only ✨

---

💜 SEE ALSO 💜

• CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7))
• DROP EVENT TRIGGER (DROP_EVENT_TRIGGER(7))

---

and that's the whole page, bestie!! 🫶 this one shipped in PostgreSQL 18.6 and the docs are dated 2026, and the page signs off as ALTER EVENT TRIGGER(7) — mwah, go alter something, but like, responsibly 💖🎀🌸