ALTER RULE

ALTER RULE

7

SQL - Language Statements

ALTER RULE

change the definition of a rule

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.

To use `ALTER RULE`, you must own the table or view that the rule
applies to.

Parameters
==========

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.

Examples
========

To rename an existing rule:

    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.

See Also
========
