Supported Versions: Current (11) / 10
Development Versions: 12 / devel

51.78. pg_publication_tables

The view pg_publication_tables provides information about the mapping between publications and the tables they contain. Unlike the underlying catalog pg_publication_rel, this view expands publications defined as FOR ALL TABLES, so for such publications there will be a row for each eligible table.

Table 51.79. pg_publication_tables Columns

Name Type References Description
pubname name pg_publication.pubname Name of publication
schemaname name pg_namespace.nspname Name of schema containing table
tablename name pg_class.relname Name of table