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 |
|
Name of publication |
schemaname |
name |
|
Name of schema containing table |
tablename |
name |
|
Name of table |