ALTER_RULE(7pg15)

💖 ALTER_RULE 💖

okay so this is ALTER_RULE(7pg15) from the PostgreSQL 15.19 docs — the manual page for changing a rule’s definition, and it’s literally giving “small but mighty” ✨

---

🎀 NAME 🎀

ALTER_RULE — change 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. That’s it — one action, zero extra drama 🎀

To use ALTER RULE, you must own the table or view that the rule applies to. Ownership check says slay or stay home, bestie 👑

🌸 PARAMETERS 🌸

• name — the name of an existing rule to alter.
• table_name — the name of the table or view that the rule applies to; it can be optionally schema-qualified.
• new_name — the new name for the rule.

🍓 EXAMPLES 🍓

To rename an existing rule:

ALTER RULE notify_all ON emp RENAME TO notify_me;

🌈 COMPATIBILITY 🌈

ALTER RULE is a PostgreSQL language extension — and so is the entire query rewrite system. PostgreSQL extension vibes, periodt 👑

🫶 SEE ALSO 🫶

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

---

xoxo, your PostgreSQL 15.19 doc bestie 💖 — dated 2026, no cap.