`pg_rewrite`
pg_rewrite
The catalog pg_rewrite stores rewrite rules for tables and views.
Table: pg_rewrite Columns
Column Type Description |
|---|
Row identifier |
Rule name |
The table this rule is for |
Event type that the rule is for: 1 = sql-select, 2 = sql-update, 3 = sql-insert, 4 = sql-delete |
Controls in which session_replication_role modes the rule fires. |
True if the rule is an |
Expression tree (in the form of a |
Query tree (in the form of a |
Note
pg_class.relhasrules must be true if a table has any rules in this catalog.