This page in other versions: 9.3 / 9.4 / current (9.5)  |  Development versions: devel



ALTER RULE -- change the definition of a 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.



The name of an existing rule to alter.


The name (optionally schema-qualified) of the table or view that the rule applies to.


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.

Add Comment

Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.

Proceed to the comment form.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group