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

NameTypeReferencesDescription
oidoid Row identifier (hidden attribute; must be explicitly selected)
pubnamename Name of the publication
pubowneroidpg_authid.oidOwner of the publication
puballtablesbool If true, this publication automatically includes all tables in the database, including any that will be created in the future.
pubinsertbool If true, INSERT operations are replicated for tables in the publication.
pubupdatebool If true, UPDATE operations are replicated for tables in the publication.
pubdeletebool If true, DELETE operations are replicated for tables in the publication.
pubtruncatebool If true, TRUNCATE operations are replicated for tables in the publication.