51.52. pg_subscription

51.52. `pg_subscription`
Prev | Up | Chapter 51. System Catalogs | Home | Next

## 51.52. `pg_subscription`

The catalog `pg_subscription` contains all existing logical replication subscriptions. For more information about logical replication see Chapter 30.

Unlike most system catalogs, `pg_subscription` is shared across all databases of a cluster: there is only one copy of `pg_subscription` per cluster, not one per database.

Access to the column `subconninfo` is revoked from normal users, because it could contain plain-text passwords.

Table 51.52. `pg_subscription` Columns

Column Type Description
`oid` `oid` Row identifier
`subdbid` `oid` (references `pg_database`.`oid`) OID of the database which the subscription resides in
`subname` `name` Name of the subscription
`subowner` `oid` (references `pg_authid`.`oid`) Owner of the subscription
`subenabled` `bool` If true, the subscription is enabled and should be replicating.
`subconninfo` `text` Connection string to the upstream database
`subslotname` `name` Name of the replication slot in the upstream database (also used for the local replication origin name); null represents `NONE`
`subsynccommit` `text` Contains the value of the `synchronous_commit` setting for the subscription workers.
`subpublications` `text[]` Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 30.1.

Prev | Up | Next
51.51. `pg_statistic_ext_data` | Home | 51.53. `pg_subscription_rel`