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.
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)