pg_publication_tables
A system catalogue view listing the mapping between publications and the tables they contain
pg_publication_tables is a system catalogue view listing the mapping between publications and the tables they contain.
pg_publication_tables was added in PostgreSQL 10 (commit 665d1fad).
Definition by PostgreSQL version
pg_publication_tables (PostgreSQL 14)
View "pg_catalog.pg_publication_tables"
Column | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
pubname | name | | |
schemaname | name | | |
tablename | name | | |
Documentation: pg_publication_tables
pg_publication_tables (PostgreSQL 13)
View "pg_catalog.pg_publication_tables"
Column | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
pubname | name | | |
schemaname | name | | |
tablename | name | | |
Documentation: pg_publication_tables
pg_publication_tables (PostgreSQL 12)
View "pg_catalog.pg_publication_tables"
Column | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
pubname | name | | |
schemaname | name | | |
tablename | name | | |
Documentation: pg_publication_tables
pg_publication_tables (PostgreSQL 11)
View "pg_catalog.pg_publication_tables"
Column | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
pubname | name | | |
schemaname | name | | |
tablename | name | | |
Documentation: pg_publication_tables
pg_publication_tables (PostgreSQL 10)
View "pg_catalog.pg_publication_tables"
Column | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
pubname | name | | |
schemaname | name | | |
tablename | name | | |
Documentation: pg_publication_tables
Change history
This view has remained unchanged since its introduction in PostgreSQL 10.
- PostgreSQL 10
- added (commit 665d1fad)
References
- PostgreSQL documentation: pg_publication_tables