PostgreSQL 15 ← 14
← Catalog atlas / pg_publication_tables
SYSTEM VIEW · System view
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.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_publication_tablesPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
pubname |
name |
Name of publicationReferences:pg_publication.pubname |
schemaname |
name |
Name of schema containing tableReferences:pg_namespace.nspname |
tablename |
name |
Name of tableReferences:pg_class.relname |
attnames |
name[] |
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.References:pg_attribute.attname |
rowfilter |
text |
Expression for the table's publication qualifying condition |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
| COLUMN | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pubname |
– | – | – | – | – | – | – | ||||||||||
schemaname |
– | – | – | – | – | – | – | ||||||||||
tablename |
– | – | – | – | – | – | – | ||||||||||
attnames |
– | – | – | – | – | – | – | – | – | – | – | – | |||||
rowfilter |
– | – | – | – | – | – | – | – | – | – | – | – |
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsPostgreSQL 10 ← 9.6Catalog added
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.