System Catalogs / System views
pg_publication_tables
Read the PG 18 manualThe view pg_publication_tables provides information about the mapping between publications and information of tables they contain.
Reading PG 18current·documented in 11 of 24 versions, 10 to 20
- Kind
- System views
- Columns in this snapshot
- 5
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 5
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
pubname | name | Name of publication pg_publication.pubname |
schemaname | name | Name of schema containing table pg_namespace.nspname |
tablename | name | Name of table 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. pg_attribute.attname |
rowfilter | text | Expression for the table's publication qualifying condition |
Column history across versions
Definition snapshot: english-manuals:096c56f390ceaaafab926f764a0… · English manual source