PG_REWRITE¶
PG_REWRITE records rewrite rules defined for tables and views.
Column | Type | Description |
|---|---|---|
rulename | Name | Name of the rule |
ev_class | OID | Name of the table that uses the rule |
ev_attr | Smallint | Column this rule is for (always 0 to indicate the entire table) |
ev_type | Char | Event type for this rule:
|
ev_enabled | Char | Controls in which mode the rule fires
|
is_instead | boolean | Its value is true if the rule is an INSTEAD rule. |
ev_qual | pg_node_tree | Expression tree (in the form of a nodeToString() representation) for the rule's qualifying condition |
ev_action | pg_node_tree | Query tree (in the form of a nodeToString() representation) for the rule's action |
state_change | Timestamp with time zone | Time when the ev_enabled field is updated. This column is available only in clusters of version 9.1.0.200 or later. |