51.40. pg_publication
The catalog
pg_publication
contains all
publications created in the database. For more on publications see
Section 30.1
.
Table 51.40.
pg_publication
Columns
Name | Type | References | Description |
---|---|---|---|
oid
|
oid
|
Row identifier | |
pubname
|
name
|
Name of the publication | |
pubowner
|
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.
|