55.41. `pg_publication`
Prev | Up | Chapter 55. System Catalogs | Home | Next

## 55.41. `pg_publication` #

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

Table 55.41. `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.
`pubmask` `bool` If true, data masking takes place for tables in the publication. That is, if a column has the masking expression, the masking expression value is sent to the subscribers instead of the actual column value.
`pubacl` `aclitem[]` Access privileges; see Section 5.7 for details

Prev | Up | Next
55.40. `pg_proc` | Home | 55.42. `pg_publication_namespace`