SYSTEM CATALOGS / SYSTEM VIEWS
pg_publication_tables
Read PG 18 manual ↗The view pg_publication_tables provides information about the mapping between publications and information of tables they contain.
- Kind
- System views
- Columns in this snapshot
- 5
- Definition source
- English manual
Columns 5
| 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
Version history 2
- PG 14 → 15changed
- PG 9.6 → 10added
Definition snapshot: english-manuals:d8b3958d1a94bb3abe6c39af8c7… · English manual source