Help Center/Data Warehouse Service/Standard Data Warehouse (9.1.0.x)/DWS System Catalogs and Views/System Catalogs/PG_PUBLICATION
Updated on 2025-10-09 GMT+08:00
View PDF

PG_PUBLICATION

PG_PUBLICATION records all the publications created in the current database. This system catalog is supported only by clusters of version 8.2.0.100 or later.

Table 1 PG_PUBLICATION columns

Column

Type

Reference

Description

OID

OID

-

Row identifier (hidden attribute; displayed only when explicitly selected)

pubname

Name

-

Publication name

pubowner

OID

PG_AUTHID.oid

Publication owner

puballtables

Boolean

-

If its value is true, the publication includes all the tables in the database, including any tables that will be created in the future.

pubinsert

Boolean

-

If its value is true, the INSERT operation is copied for the tables in the publication.

pubupdate

Boolean

-

If its value is true, the UPDATE operation is copied for the tables in the publication.

pubdelete

Boolean

-

If its value is true, the DELETE operation is copied for the tables in the publication.

pubtruncate

Boolean

-

If its value is true, the TRUNCATE operation is copied for the tables in the publication.

Examples

View all releases.

1
2
3
4
5
SELECT * FROM pg_publication;
 pubname | pubowner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 
---------+----------+--------------+-----------+-----------+-----------+-------------
 mypub   |       10 | t            | t         | t         | t         | t
(1 row)
Parent Topic: System Catalogs