Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
52.46. pg_rewrite
Prev UpChapter 52. System CatalogsHome Next

52.46. pg_rewrite

The catalogpg_rewrite stores rewrite rules for tables and views.

Table 52.46. pg_rewrite Columns

Column Type

Description

oidoid

Row identifier

rulenamename

Rule name

ev_classoid (referencespg_class.oid)

The table this rule is for

ev_typechar

Event type that the rule is for: 1 =SELECT, 2 =UPDATE, 3 =INSERT, 4 =DELETE

ev_enabledchar

Controls in whichsession_replication_role modes the rule fires.O = rule fires inorigin andlocal modes,D = rule is disabled,R = rule fires inreplica mode,A = rule fires always.

is_insteadbool

True if the rule is anINSTEAD rule

ev_qualpg_node_tree

Expression tree (in the form of anodeToString() representation) for the rule's qualifying condition

ev_actionpg_node_tree

Query tree (in the form of anodeToString() representation) for the rule's action


Note

pg_class.relhasrules must be true if a table has any rules in this catalog.


Prev Up Next
52.45. pg_replication_origin Home 52.47. pg_role_password
pdfepub
Go to Postgres Pro Standard 15
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp