PG_REWRITE

PG_REWRITE records rewrite rules defined for tables and views.

Table 1 PG_REWRITE columns

Column

Type

Description

rulename

Name

Name of the rule

ev_class

OID

Name of the table that uses the rule

ev_attr

Smallint

Column this rule is for (always 0 to indicate the entire table)

ev_type

Char

Event type for this rule:

  • 1 = SELECT

  • 2 = UPDATE

  • 3 = INSERT

  • 4 = DELETE

ev_enabled

Char

Controls in which mode the rule fires

  • O: The rule fires in "origin" and "local" modes.

  • D: The rule is disabled.

  • R: The rule fires in "replica" mode.

  • A: The rule always fires.

is_instead

boolean

Its value is 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

state_change

Timestamp with time zone

Time when the ev_enabled field is updated. This column is available only in clusters of version 9.1.0.200 or later.

last updated: 2025-09-11 15:37 UTC - commit: 0936b7736854a5d1860e596c7749139402140c8a