52.17. pg_publication_tables
The view pg_publication_tables provides information about the mapping between publications and information of tables they contain. Unlike the underlying catalog pg_publication_rel, this view expands publications defined as FOR ALL TABLES and FOR TABLES IN SCHEMA, so for such publications there will be a row for each eligible table.
Table 52.17. pg_publication_tables Columns
Column Type Description |
|---|
Name of publication |
Name of schema containing table |
Name of table |
Names of table columns included in the publication. This contains all the columns of the table when the user didn't specify the column list for the table. |
Expression for the table's publication qualifying condition |