The pg_publication catalog provides information about logical replication publications.
| Column name | Data type | Description |
|——————|——————————|————-|
| oid | oid | A row identifier. |
| pubname | name | The name of the publication. |
| pubowner | oid (references pg_authid.oid)| The OID of the role that owns the publication. |
| puballtables | bool | Specifies whether the publication automatically includes all tables in the database, including those created in the future (TRUE) or not (FALSE). |
| pubinsert | bool | Specifies whether INSERT operations are replicated for the tables in the publication (TRUE) or not (FALSE). |
| pubupdate | bool | Specifies whether UPDATE operations are replicated for the tables in the publication (TRUE) or not (FALSE). |
| pubdelete | bool | Specifies whether DELETE operations are replicated for the tables in the publication (TRUE) or not (FALSE). |
| ‘pubtruncate | bool | Specifies whether TRUNCATE operations are replicated for the tables in the publication (TRUE) or not (FALSE). |
| pubviaroot | bool | Specifies whether operations on a leaf partition are replicated using the identity and schema of the topmost partitioned ancestor mentioned in the publication (TRUE) or not (FALSE). |
| pubgencols | char | Controls how to handle generated column replication when there is no publication column list. <br>The possible values are:<br>{::nomarkdown}<ul><li>{:/}n – Generated columns are not replicated.{::nomarkdown}</li><li>{:/}s` – Stored generated columns are replicated. |