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.

     
          SELECT * FROM pg_publication;
 pubname | pubowner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 
---------+----------+--------------+-----------+-----------+-----------+-------------
 mypub   |       10 | t            | t         | t         | t         | t
(1 row)