Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
51.44. pg_rewrite
Prev UpChapter 51. System CatalogsHome Next

51.44. pg_rewrite

The catalogpg_rewrite stores rewrite rules for tables and views.

Table 51.44. 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
51.43. pg_replication_origin Home 51.45. pg_role_password
pdfepub
Go to Postgres Pro Standard 14
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp