pg_rewrite
pg_rewrite#
The pg_rewrite
system catalog table stores rewrite rules for tables and views. pg_class.relhasrules
must be true if a table has any rules in this catalog.
Table 1. pg_catalog.pg_rewrite
column |
type |
references |
description |
---|---|---|---|
|
oid |
The object ID |
|
|
name |
Rule name |
|
|
oid |
pg_class.oid |
The table this rule is for |
|
char |
Event type that the rule is for: 1 = SELECT, 2 = UPDATE, 3 = INSERT, 4 = DELETE |
|
|
char |
Controls in which session replication role mode the rule fires. Always O, rule fires in origin mode. |
|
|
boolean |
True if the rule is an |
|
|
pg_node_tree |
Expression tree (in the form of a |
|
|
pg_node_tree |
Query tree (in the form of a |