• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_REWRITE

PG_REWRITE

PG_REWRITE stores rewrite rules for tables and views.

Table 1 PG_REWRITE columns

Name

Type

Description

rulename

name

Rule Name

ev_class

oid

Name of the table that uses the rule

ev_attr

smallint

Column this rule is for (always zero 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 = rule fires in "origin" and "local" modes
  • D = rule is disabled
  • R = rule fires in "replica" mode
  • A = 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