PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_rewrite

Read PG 18 manual ↗

The catalog pg_rewrite stores rewrite rules for tables and views.

Kind: System catalogs
Columns in this snapshot: 8
Definition source: English manual

Columns 8

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`rulename`	`name`	Rule name
`ev_class`	`oid`	The table this rule is for pg_class.oid
`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

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rulename`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`ev_class`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`ev_type`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`ev_enabled`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`is_instead`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`ev_qual`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`ev_action`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`ev_attr`	●	●	●	●	·	·	·	·	·	·	·	·	·	·	·	·	·	·

Version history 5

Definition snapshot: english-manuals:88d6b72cdabe41b4f98925254bb… · English manual source