Updated on 2024-09-02 GMT+08:00

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

Name

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)