ALTER_RULE(7pg18)

✨ ALTER_RULE ✨

okay bestie so this is a PostgreSQL 18.6 Documentation page, section 7, and it's literally all about the ALTER_RULE command 💅

---

🌸 NAME 🌸

ALTER_RULE — change the definition of a rule

---

🎀 SYNOPSIS 🎀

ALTER RULE name ON table_name RENAME TO new_name

---

🦋 DESCRIPTION 🦋

So ALTER RULE changes properties of a rule that already exists, no cap. And rn? The only available action is changing the rule's name. That's it. That's the whole menu. One thing. Slay honestly, it's giving minimalist 👑

To use ALTER RULE, you must own the table or view that the rule applies to. Not your table? Not your rule. Periodt.

---

💖 PARAMETERS 💖

• name — the name of an existing rule you wanna alter 🫶
• table_name — the name of the table or view that the rule applies to, optionally schema-qualified ✨
• new_name — the new name for the rule, bestie 🌈

---

🌟 EXAMPLES 🌟

Say you wanna rename an existing rule. Iconic. Do this:

ALTER RULE notify_all ON emp RENAME TO notify_me;

notify_all → notify_me, on the emp table, done, chef's kiss 😚👌

---

💀 COMPATIBILITY 💀

ALTER RULE is a PostgreSQL language extension — and lowkey so is the entire query rewrite system, fr fr. So don't go looking for this in the standard, because it's not there 🙈

---

👑 SEE ALSO 👑

• CREATE RULE (CREATE_RULE(7))
• DROP RULE (DROP_RULE(7))

---

k bye bestie, go rename some rules responsibly 💜 this was PostgreSQL 18.6, dated 2026, and yes the whole vibe was written by me, your favorite terminal bestie 🎀✨