---
title: "pg_rewrite"
id: catalog-pg-rewrite
pg_version: "20devel"
---

<a id="catalog-pg-rewrite"></a>

## 52.50. pg_rewrite

The catalog pg_rewrite stores rewrite rules for tables and views. 

**pg_rewrite Columns**

| Column Type | Description | 
| --- | --- |
| `oid` `oid` | Row identifier |
| `rulename` `name` | Rule name |
| `ev_class` `oid` (references [pg_class](catalog-pg-class.md).`oid`) | The table this rule is for |
| `ev_type` `char` | Event type that the rule is for: 1 = [SELECT](sql-select.md), 2 = [UPDATE](sql-update.md), 3 = [INSERT](sql-insert.md), 4 = [DELETE](sql-delete.md) |
| `ev_enabled` `char` | Controls in which [`session_replication_role` (`enum`)](runtime-config-client.md#guc-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.