Skip to content
← Catalog atlas / pg_publication_rel

SYSTEM CATALOG · System catalog

pg_publication_rel

PostgreSQL documentation ↗Source definition ↗

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

First seen PG 10Last seen PG 19Columns 5
9.09.19.29.39.49.59.610111213141516171819β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_publication_rel
COLUMNTYPEDESCRIPTION
oid oidNOT NULL Row identifier
prpubid oidNOT NULL Reference to publicationReferences:pg_publication.oid
prrelid oidNOT NULL Reference to relationReferences:pg_class.oid
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 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.References:pg_attribute.attnum

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Common system columns 6

System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.

ColumnsTypeattnum
tableoidoid-6
cmaxcid-5
xmaxxid-4
cmincid-3
xminxid-2
ctidtid-1

Column evolution matrix

Hover a cell for the column type
PresentAdded / type or attribute changeRemoved
COLUMN9.09.19.29.39.49.59.610111213141516171819
oid – – – – – – –
prpubid – – – – – – –
prrelid – – – – – – –
prqual – – – – – – – – – – – –
prattrs – – – – – – – – – – – –
prexcept – – – – – – – – – – – – – – – –

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 19 ← 18

+ prexcept1 column description updatesCatalog description updated

PostgreSQL 18 ← 17

Catalog description updated

PostgreSQL 17 ← 16

Catalog description updated

PostgreSQL 15 ← 14

+ prqual+ prattrsCatalog description updated

PostgreSQL 14 ← 13

Catalog description updated

PostgreSQL 13 ← 12

1 column description updatesCatalog description updated

PostgreSQL 12 ← 11

~ oid: implicit → ordinary1 column description updatesCatalog description updated

PostgreSQL 11 ← 10

Catalog description updated

PostgreSQL 10 ← 9.6Catalog added

+ oid+ prpubid+ prrelid

Compare any two versions

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.