ALTER_RULE(7pg17)

🎀 NAME 🎀

okay bestie, welcome to the ALTER_RULE(7pg17) page — up top it’s literally ALTER RULE(7) — from the PostgreSQL 17.11 Documentation 💅✨. This manual is called ALTER_RULE, and 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 — that’s the whole menu, no cap 🍓.

To use ALTER RULE, you must own the table or view that the rule applies to. Like, you gotta be the owner-owner, bestie 👑.

🌸 PARAMETERS 🌸

• name — the name of an existing rule to alter. Yep, the rule has to already exist 💖.
• table_name — the name (optionally schema-qualified) of the table or view that the rule applies to. Schema-qualified is allowed, iconically ✨.
• new_name — the new name for the rule. Fresh name, same rule, slay 🦋.

🦋 EXAMPLES 🦋

To rename an existing rule, you literally do this:

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. So yeah, this is Postgres-specific territory, bestie — periodt 💅.

🧚 SEE ALSO 🧚

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

mwah 💖 that’s the whole page — source/version: PostgreSQL 17.11, date: 2026, and the manual page is ALTER RULE(7). byeee 🫶✨