pg_publication_rel

The pg_publication_rel catalog provides information about the mapping of relations to publications.

Column name Data type Description
oid oid A row identifier.
prpubid oid (references pg_publication.oid) The reference to the publication.
prrelid oid (references pg_class.oid) The reference to the relation.
prqual pg_node_tree The expression tree, represented as nodeToString(), for the relation’s publication qualifying condition.
NULL – No publication qualifying condition.
prattrs int2vector The array of values indicating which table columns are part of the publication. For example, the 1 3 array means that the first and third table columns are published.
NULL – All columns are published.