52.39. `pg_publication`
Prev | Up | Chapter 52. System Catalogs | Home | Next

## 52.39. `pg_publication`

The catalog `pg_publication` contains all publications created in the database. For more on publications see Section 30.1.

Table 52.39. `pg_publication` Columns

Column Type Description
`oid` `oid` Row identifier
`pubname` `name` Name of the publication
`pubowner` `oid` (references `pg_authid`.`oid`) Owner of the publication
`puballtables` `bool` If true, this publication automatically includes all tables in the database, including any that will be created in the future.
`pubinsert` `bool` If true, `INSERT` operations are replicated for tables in the publication.
`pubupdate` `bool` If true, `UPDATE` operations are replicated for tables in the publication.
`pubdelete` `bool` If true, `DELETE` operations are replicated for tables in the publication.
`pubtruncate` `bool` If true, `TRUNCATE` operations are replicated for tables in the publication.
`pubviaroot` `bool` If true, operations on a leaf partition are replicated using the identity and schema of its topmost partitioned ancestor mentioned in the publication instead of its own.

Prev | Up | Next
52.38. `pg_proc` | Home | 52.40. `pg_publication_rel`