↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10
Pre-release documentation. PostgreSQL 19 Beta 3 is a testing release. The final release may differ.
52.47. pg_publication_rel
Prev  Up Chapter 52. System Catalogs Home  Next

52.47. pg_publication_rel #

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 53.20 for a more user-friendly view of this information.

Table 52.47. 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 table

prexcept bool

True if the table is excluded from the publication. See EXCEPT.

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.

Prev  Up  Next
52.46. pg_publication_namespace  Home  52.48. pg_range

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.