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

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

Categories

DDL, Rules, SQL command

See also

CREATE RULE, DROP RULE