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