This page in other versions: current (10)  |  Development versions: devel / 11

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
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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group