pg_publication_rel

A system 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.

Definition by PostgreSQL version

pg_publication_rel (PostgreSQL 14)

      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" PRIMARY KEY, btree (oid)
    "pg_publication_rel_prrelid_prpubid_index" UNIQUE CONSTRAINT, btree (prrelid, prpubid)
    

Documentation: pg_publication_rel

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 been modified since it was added in PostgreSQL 10.

Categories

Replication, System catalogue

See also

pg_publication, pg_publication_tables