Contents
ALTER RULE
An SQL command for modifying the definition of a rule
ALTER RULE
is a DDL command for modifying the definition of a rule.
ALTER RULE
was added in PostgreSQL 9.3.
Usage
Currently the only property of a rule which can be modified is its name.
Change history
- PostgreSQL 9.3
- added (commit c61e26ee)
ALTER RULE
has not been modified since it was added in PostgreSQL 9.3.
Examples
Basic usage example for ALTER RULE
:
postgres=# ALTER RULE foobar ON foo RENAME TO foo_insert_rule; ALTER RULE
References
- PostgreSQL documentation: ALTER RULE