Postgresql 中文操作指南
53.42. pg_publication_rel #
目录 pg_publication_rel 包含数据库中关系与发布之间的映射。这是一个多对多映射。另请参阅 Section 54.17 了解此信息的更友好的视图。
The catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section 54.17 for a more user-friendly view of this information.
Table 53.42. pg_publication_rel Columns
Table 53.42. pg_publication_rel Columns
Column Type Description |
oid oid Row identifier |
prpubid oid (references pg_publication.oid) Reference to publication |
prrelid oid (references pg_class.oid) Reference to relation |
prqual pg_node_tree Expression tree (in nodeToString() representation) for the relation’s publication qualifying condition. Null if there is no publication qualifying condition. |
prattrs int2vector (references pg_attribute.attnum) This is an array of values that indicates which table columns are part of the publication. For example, a value of 1 3 would mean that the first and the third table columns are published. A null value indicates that all columns are published. |