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.
- PostgreSQL 10
- (commit 665d1fad)
References
- PostgreSQL documentation: pg_publication_rel