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 |
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/10/view-pg-publication-tables.html