PostgreSQL

52.78. `pg_publication_tables`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.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 52.79. pg_publication_tables Columns

Name Type References Description

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

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

Prev	Up	Next
52.77. `pg_prepared_xacts`	Home	52.79. `pg_replication_origin_status`

52.77. pg_prepared_xacts

Home

52.79. pg_replication_origin_status

PostgreSQL

52.78. pg_publication_tables

52.78. `pg_publication_tables`