pg_publication_rel

A system catalogue table storing the mapping between relations and publications

pg_publication_rel is a system catalogue table storing the mapping between relations and publications.

pg_publication_rel was added in PostgreSQL 10 (commit 665d1fad).

Definition by PostgreSQL version

pg_publication_rel (PostgreSQL 13)

      Table "pg_catalog.pg_publication_rel"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 oid     | oid  |           | not null |
 prpubid | oid  |           | not null |
 prrelid | oid  |           | not null |
Indexes:
    "pg_publication_rel_oid_index" UNIQUE, btree (oid)
    "pg_publication_rel_prrelid_prpubid_index" UNIQUE, btree (prrelid, prpubid)
    

Documentation: pg_publication_rel

pg_publication_rel (PostgreSQL 12)

      Table "pg_catalog.pg_publication_rel"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 oid     | oid  |           | not null |
 prpubid | oid  |           | not null |
 prrelid | oid  |           | not null |
Indexes:
    "pg_publication_rel_oid_index" UNIQUE, btree (oid)
    "pg_publication_rel_prrelid_prpubid_index" UNIQUE, btree (prrelid, prpubid)
    

Documentation: pg_publication_rel

pg_publication_rel (PostgreSQL 11)

      Table "pg_catalog.pg_publication_rel"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 prpubid | oid  |           | not null |
 prrelid | oid  |           | not null |
Indexes:
    "pg_publication_rel_oid_index" UNIQUE, btree (oid)
    "pg_publication_rel_prrelid_prpubid_index" UNIQUE, btree (prrelid, prpubid)
    

Documentation: pg_publication_rel

pg_publication_rel (PostgreSQL 10)

      Table "pg_catalog.pg_publication_rel"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 prpubid | oid  |           | not null |
 prrelid | oid  |           | not null |
Indexes:
    "pg_publication_rel_oid_index" UNIQUE, btree (oid)
    "pg_publication_rel_prrelid_prpubid_index" UNIQUE, btree (prrelid, prpubid)
    

Documentation: pg_publication_rel

Change history

This table has not changed since it was added in PostgreSQL 10.

Categories

Replication, System catalogue

See also

pg_publication, pg_publication_tables