ALTER_RULE(7pg16)

📦 version 16.15, in opensuse-leap 16.0

💅 ALTER RULE (7) — the glow-up page for your rules

ok so bestie, welcome to the <pink>PostgreSQL 16.15</pink> corner of the manual that's literally just about renaming rules. That's it. That's the whole vibe. It's short, it's sweet, it's giving "micro-manpage" energy and honestly? We love a concise icon. ✨

✨ NAME ✨

ALTER_RULE — change the definition of a rule 🎀

🌸 SYNOPSIS 🌸

ALTER RULE name ON table_name RENAME TO new_name

That's the one and only shape this command comes in, no cap.

💖 DESCRIPTION 💖

So here's the tea: ALTER RULE changes properties of an existing rule. And when I say "properties," I mean... okay don't get too excited, because right now the only available action is changing the rule's name. That's the entire menu. One item. A solo act. Main character energy, honestly. 👑

But real talk before you go renaming things: to use ALTER RULE, you must own the table or view that the rule applies to. Not vibes-based ownership, actual ownership. If it's not yours, the answer is no. 🙈

🦋 PARAMETERS 🦋

  • name — the name of an existing rule you wanna alter. Gotta be a rule that's already out here existing, bestie.
  • table_name — the name (optionally schema-qualified) of the table or view that the rule applies to. Yes, optional schema qualification is allowed, we're fancy like that. 💅
  • new_name — the new name for the rule. The fresh identity. The rebrand. 🦋

⭐ EXAMPLES ⭐

Wanna rename an existing rule? Say less. Here's the whole move:

ALTER RULE notify_all ON emp RENAME TO notify_me;

Look at that. notify_all walked in, notify_me walked out. Iconic. 🔥

🌈 COMPATIBILITY 🌈

ALTER RULE is a <purple>PostgreSQL language extension</purple> — and ngl, so is the entire query rewrite system. So if you're out here expecting this to be standard SQL... it's not, and that's just how it is, fr fr. 🫶

🎀 SEE ALSO 🎀

okay that's genuinely the whole page, no filler, no extra lore 💀 if you came here looking for forty options you're in the wrong manpage, bestie — this one's a one-trick pony and she's slaying at it 💜

PostgreSQL 16.15 · <lavender>2026</lavender> · ALTER RULE(7) — mwah, go forth and rename responsibly, iykyk 🌸🧚💖

📦 where this page comes from