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

Categories

Logical replication, Replication, System catalogue

See also

pg_publication_rel