pg_publication_tables

A system view listing the mapping between publications and their tables

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.

Definition by PostgreSQL version

pg_publication_tables (PostgreSQL 15)

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

Examples

Example usage for pg_publication_tables:

postgres=# \dt
        List of relations
 Schema | Name | Type  |  Owner
--------+------+-------+----------
 public | bar  | table | postgres
 public | foo  | table | postgres
(2 rows)

postgres=# CREATE PUBLICATION foo_publication
             FOR TABLE foo;
CREATE PUBLICATION

postgres=# CREATE PUBLICATION all_publication
             FOR ALL TABLES;
CREATE PUBLICATION

postgres=# SELECT * FROM pg_publication_tables;
     pubname     | schemaname | tablename
-----------------+------------+-----------
 foo_publication | public     | foo
 all_publication | public     | foo
 all_publication | public     | bar
(3 rows)

Categories

Logical replication, Replication, System catalogue

See also

pg_publication_rel, pg_publication