---
title: "pg_publication"
id: catalog-pg-publication
pg_version: "20devel"
---

<a id="catalog-pg-publication"></a>

## 52.45. pg_publication

The catalog pg_publication contains all publications created in the database. For more on publications see [Section 29.1](logical-replication-publication.md). 

**pg_publication Columns**

| Column Type | Description | 
| --- | --- |
| `oid` `oid` | Row identifier |
| `pubname` `name` | Name of the publication |
| `pubowner` `oid` (references [pg_authid](catalog-pg-authid.md).`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. |
| `puballsequences` `bool` | If true, this publication automatically includes all sequences in the database, including any that will be created in the future. |
| `pubinsert` `bool` | If true, [INSERT](sql-insert.md) operations are replicated for tables in the publication. |
| `pubupdate` `bool` | If true, [UPDATE](sql-update.md) operations are replicated for tables in the publication. |
| `pubdelete` `bool` | If true, [DELETE](sql-delete.md) operations are replicated for tables in the publication. |
| `pubtruncate` `bool` | If true, [TRUNCATE](sql-truncate.md) 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. |