ALTER_RULE(7pg14)

✨ NAME ✨

okay so welcome to the ALTER RULE(7) page from the PostgreSQL 14.24 documentation 💅 the main character here is ALTER_RULE — it changes the definition of a rule. 🎀

🦋 SYNOPSIS 🦋

ALTER RULE name ON table_name RENAME TO new_name

💖 DESCRIPTION 💖

ALTER RULE changes properties of an existing rule. Currently, the only available action is to change the rule’s name. ✨

To use ALTER RULE, you must own the table or view that the rule applies to. No cap — that ownership requirement is literally part of the vibe check. 🫶

bestie, if you don’t own the table or view the rule applies to, this is not your moment 💀

🎀 PARAMETERS 🎀

• name — the name of an existing rule to alter. like, which rule are we giving a glow-up? 💅
• table_name — the name (optionally schema-qualified) of the table or view that the rule applies to. 🦋
• new_name — the new name for the rule. fresh name, who dis? 🎀

🔥 EXAMPLES 🔥

To rename an existing rule:

ALTER RULE notify_all ON emp RENAME TO notify_me;

🌈 COMPATIBILITY 🌈

ALTER RULE is a PostgreSQL language extension, as is the entire query rewrite system. 💜

👑 SEE ALSO 👑

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

---

mwah 💋 that’s the whole page — PostgreSQL 14.24, dated 2026, ALTER RULE(7) out. 👑