PG_REWRITE

PG_REWRITE records rewrite rules defined for tables and views.

**Table 1** PG_REWRITE columns
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: 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
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.