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

Table 52.40. 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.

| |

pubgencols char

Controls how to handle generated column replication when there is no publication column list: n = generated columns in the tables associated with the publication should not be replicated, s = stored generated columns in the tables associated with the publication should be replicated.

|