Changes 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.
Compatibility
ALTER RULE
is a Greenplum Database language extension, as is the entire query rewrite system.
See Also
Parent topic: SQL Commands
Content feedback and comments