PG_REWRITE

rulename

name

Name of the rule

ev_class

oid

Name of the table that uses the rule

ev_attr

smallint

Field to which the rule applies. Currently, the value is 0, indicating the entire table.

ev_type

"char"

Event type for this rule:

• 1 = SELECT
• 2 = UPDATE
• 3 = INSERT
• 4 = DELETE

ev_enabled

"char"

Controls in which mode the rule fires

• O: The rule fires in "origin" and "local" modes.
• D: The rule is disabled.
• R: The rule fires in "replica" mode.
• A: The rule always 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