ALTER RULE

change the definition of a rule

English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

anchor: SQL-ALTERRULE
file: sql-alterrule.html
lang: en
name: ALTER RULE
purpose: change the definition of a rule
purpose zh: 修改一条重写规则的定义
sections same as: Unknown
slug: 18
synopsis html: ALTER RULE <code>name</code> ON <code>table_name</code> RENAME TO <code>new_name</code>
synopsis text: ALTER RULE name ON table_name RENAME TO new_name

Syntax

ALTER RULE name ON table_name RENAME TO new_name

Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

ALTER RULE name ON table_name RENAME TO new_name

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.

name: The name of an existing rule to alter.
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.

To rename an existing rule:

ALTER RULE notify_all ON emp RENAME TO notify_me;

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

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:5308f09328bf0fed18b104dcc1921e37e4b8210b70bed8cf39426e7cf4fdb5a1

Text language: en · wiki-repair-20261023:5308f09328bf0fed18b104dcc1921e37e4b8210b70bed8cf39426e7cf4fdb5a1