# phpman > man > ALTER_RULE(7)

ALTER [RULE(7)](https://www.chedong.com/phpMan.php/man/RULE/7/markdown)                      PostgreSQL 14.23 Documentation                      ALTER [RULE(7)](https://www.chedong.com/phpMan.php/man/RULE/7/markdown)



## NAME
       ALTER_RULE - change 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.

       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
       CREATE RULE (**CREATE**___**[RULE**(7)](https://www.chedong.com/phpMan.php/man/RULE/7/markdown)), DROP RULE (**DROP**___**[RULE**(7)](https://www.chedong.com/phpMan.php/man/RULE/7/markdown))



PostgreSQL 14.23                                2026                                   ALTER [RULE(7)](https://www.chedong.com/phpMan.php/man/RULE/7/markdown)