PG_REWRITE

PG_REWRITE records rewrite rules defined for tables and views.

Table 1 PG_REWRITE columns

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 this rule - 1 = SELECT - 2 = UPDATE - 3 = INSERT - 4 = DELETE
ev_enabled	"char"	Controls the mode in which the rule is triggered. - O: The rule is triggered in origin and local modes. - D: The rule is disabled. - R: The rule is triggered in replica mode. - A: The rule is always triggered.
is_instead	boolean	The value is true if the rule is of the INSTEAD type.
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