Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

PG_REWRITE

Updated on 2024-12-19 GMT+08:00

PG_REWRITE records rewrite rules defined for tables and views.

Table 1 PG_REWRITE columns

Name

Type

Description

rulename

name

Name of the rule

ev_class

oid

Name of the table that uses the rule

ev_attr

smallint

Field to which the rule applies. Currently, the value is 0, indicating 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

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback