历史版本。 PostgreSQL 9.2 已结束支持。 2017-11-09. 请参阅 当前版本手册.
45.37. pg_rewrite #
目录pg_rewrite存储对于表和视图的重写规则。
表 45.37. pg_rewrite 列
| Name | Type | References | Description |
|---|---|---|---|
rulename | name | Rule name | |
ev_class | oid | | The table this rule is for |
ev_attr | int2 | The column this rule is for (currently, always -1 to indicate the whole table) | |
ev_type | char | Event type that the rule is for: 1 = SELECT, 2 =
UPDATE, 3 = INSERT, 4 =
DELETE
| |
ev_enabled | char | Controls in which session_replication_role modes
the rule fires.
O = rule fires in “origin” and “local” modes,
D = rule is disabled,
R = rule fires in “replica” mode,
A = rule fires always.
| |
is_instead | bool | 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
|
注意
如果一个表在这个目录中有任何规则，pg_class.relhasrules必须为真。