pg_publication_tables — PostgreSQL system view

The PostgreSQL pg_publication_tables system view: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  2 min read

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_publication_tables system view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • pubname name references pg_publication.pubname
    Name of publication
  • schemaname name references pg_namespace.nspname
    Name of schema containing table
  • tablename name references pg_class.relname
    Name of table
  • attnames name[] references pg_attribute.attname
    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.
  • rowfilter text
    Expression for the table’s publication qualifying condition

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_publication_tables.