51.40. pg_publication
The catalog pg_publication contains all publications created in the database. For more on publications see Section 31.1.
Table 51.40. pg_publication Columns
| Name | Type | References | Description |
|---|---|---|---|
oid |
oid |
Row identifier (hidden attribute; must be explicitly selected) | |
pubname |
name |
Name of the publication | |
pubowner |
oid |
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. |
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/10/catalog-pg-publication.html