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 |
---|
Row identifier |
Name of the publication |
Owner of the publication |
If true, this publication automatically includes all tables in the database, including any that will be created in the future. |
If true, INSERT operations are replicated for tables in the publication. |
If true, UPDATE operations are replicated for tables in the publication. |
If true, DELETE operations are replicated for tables in the publication. |
If true, TRUNCATE operations are replicated for tables in the publication. |
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. |
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. |
Access privileges; see Section 5.7 for details |