HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

PG_REWRITE

PG_REWRITE records rewrite rules defined for tables and views.

Table 1 PG_REWRITE columns

Name Type Description
oid oid Row identifier (hidden attribute, which must be specified)
rulename name Name of a rule
ev_class oid Name of the table that uses the rule
ev_attr smallint Column to which this rule applies (always 0 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 the mode in which the rule is triggered.
- O: The rule is triggered in origin and local modes.
- D: The rule is disabled.
- R: The rule is triggered in replica mode.
- A: The rule is always triggered.
is_instead boolean The value is true if the rule is of the INSTEAD type.
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
Copyright © 2011-2024 www.enmotech.com All rights reserved.