From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/catalog-pg-rewrite.html | 64 +++++++++++++++++++++++++++++++ 1 file changed, 64 insertions(+) create mode 100644 doc/src/sgml/html/catalog-pg-rewrite.html (limited to 'doc/src/sgml/html/catalog-pg-rewrite.html') diff --git a/doc/src/sgml/html/catalog-pg-rewrite.html b/doc/src/sgml/html/catalog-pg-rewrite.html new file mode 100644 index 0000000..ae147e8 --- /dev/null +++ b/doc/src/sgml/html/catalog-pg-rewrite.html @@ -0,0 +1,64 @@ + +51.43. pg_rewrite
51.43. pg_rewrite
Prev UpChapter 51. System CatalogsHome Next

51.43. pg_rewrite

+ The catalog pg_rewrite stores rewrite rules for tables and views. +

Table 51.43. pg_rewrite Columns

+ Column Type +

+

+ Description +

+ oid oid +

+

+ Row identifier +

+ rulename name +

+

+ Rule name +

+ ev_class oid + (references pg_class.oid) +

+

+ The table this rule is for +

+ 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 +


Note

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

Prev Up Next
51.42. pg_replication_origin Home 51.44. pg_seclabel
\ No newline at end of file -- cgit v1.2.3