Contents

pg_publication

A system catalogue table storing all publications created in the database

pg_publication is a system catalogue table storing all publications created in the database.

pg_publication was added in PostgreSQL 10.

psql commands

  • \dRp[+] - lists available publications

Definition by PostgreSQL version

pg_publication (PostgreSQL 13)

            Table "pg_catalog.pg_publication"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null |
 pubname      | name    |           | not null |
 pubowner     | oid     |           | not null |
 puballtables | boolean |           | not null |
 pubinsert    | boolean |           | not null |
 pubupdate    | boolean |           | not null |
 pubdelete    | boolean |           | not null |
 pubtruncate  | boolean |           | not null |
 pubviaroot   | boolean |           | not null |
Indexes:
    "pg_publication_oid_index" UNIQUE, btree (oid)
    "pg_publication_pubname_index" UNIQUE, btree (pubname)

Documentation: pg_publication

pg_publication (PostgreSQL 12)

            Table "pg_catalog.pg_publication"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null |
 pubname      | name    |           | not null |
 pubowner     | oid     |           | not null |
 puballtables | boolean |           | not null |
 pubinsert    | boolean |           | not null |
 pubupdate    | boolean |           | not null |
 pubdelete    | boolean |           | not null |
 pubtruncate  | boolean |           | not null |
Indexes:
    "pg_publication_oid_index" UNIQUE, btree (oid)
    "pg_publication_pubname_index" UNIQUE, btree (pubname)

Documentation: pg_publication

pg_publication (PostgreSQL 11)

            Table "pg_catalog.pg_publication"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 pubname      | name    |           | not null |
 pubowner     | oid     |           | not null |
 puballtables | boolean |           | not null |
 pubinsert    | boolean |           | not null |
 pubupdate    | boolean |           | not null |
 pubdelete    | boolean |           | not null |
 pubtruncate  | boolean |           | not null |
Indexes:
    "pg_publication_oid_index" UNIQUE, btree (oid)
    "pg_publication_pubname_index" UNIQUE, btree (pubname)

Documentation: pg_publication

pg_publication (PostgreSQL 10)

            Table "pg_catalog.pg_publication"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 pubname      | name    |           | not null |
 pubowner     | oid     |           | not null |
 puballtables | boolean |           | not null |
 pubinsert    | boolean |           | not null |
 pubupdate    | boolean |           | not null |
 pubdelete    | boolean |           | not null |
Indexes:
    "pg_publication_oid_index" UNIQUE, btree (oid)
    "pg_publication_pubname_index" UNIQUE, btree (pubname)

Documentation: pg_publication

Change history

Categories

Replication, System catalogue

See also

pg_publication_rel, ALTER PUBLICATION, CREATE PUBLICATION, DROP PUBLICATION