PostgreSQL

PostgreSQL Elephant Logo

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

+

Prev Up Next

51.77. pg_prepared_xacts

Home

51.79. pg_replication_origin_status

Copyright © 1996-2023 The PostgreSQL Global Development Group