Supported Versions: Current (11) / 10 / 9.6 / 9.5 / 9.4
Development Versions: 12 / devel
Unsupported versions: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the supported versions listed above instead.

51.44. pg_rewrite

The catalog pg_rewrite stores rewrite rules for tables and views.

Table 51.44. pg_rewrite Columns

Name Type References Description
oid oid   Row identifier
rulename name   Rule name
ev_class oid pg_class.oid The table this rule is for
ev_type char   Event type that the rule is for: 1 = SELECT, 2 = UPDATE, 3 = INSERT, 4 = DELETE
ev_enabled char   Controls in which session_replication_role modes the rule fires. O = rule fires in origin and local modes, D = rule is disabled, R = rule fires in replica mode, A = rule fires always.
is_instead bool   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

Note

pg_class.relhasrules must be true if a table has any rules in this catalog.