PG_REWRITE
PG_REWRITE records rewrite rules defined for tables and views.
Name |
Type |
Description |
---|---|---|
oid |
oid |
Row identifier (hidden attribute, which must be specified). |
rulename |
name |
Name of a rule. |
ev_class |
oid |
Name of the table that uses the rule. |
ev_attr |
smallint |
Column to which this rule applies (always 0 to indicate the entire table). |
ev_type |
"char" |
Event type for the rule.
|
ev_enabled |
"char" |
Controls the mode in which the rule is triggered.
|
is_instead |
Boolean |
The value is true if the rule is of the INSTEAD type. Otherwise, the value is false. |
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.