PostgreSQL

52.52. `pg_subscription`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.52. `pg_subscription`

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

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 52.52. pg_subscription Columns

Name Type References Description

Name	Type	References	Description
`oid`	`oid`		Row identifier (hidden attribute; must be explicitly selected)
`subdbid`	`oid`	`pg_database.oid`	OID of the database which the subscription resides in
`subname`	`name`		Name of the subscription
`subowner`	`oid`	`pg_authid.oid`	Owner of the subscription
`subenabled`	`bool`		If true, the subscription is enabled and should be replicating.
`subsynccommit`	`text`		Contains the value of the `synchronous_commit` setting for the subscription workers.
`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`
`subpublications`	`text[]`		Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 31.1.

oid

Row identifier (hidden attribute; must be explicitly selected)

subdbid

oid

pg_database.oid

OID of the database which the subscription resides in

subname

name

Name of the subscription

subowner

oid

pg_authid.oid

Owner of the subscription

subenabled

bool

If true, the subscription is enabled and should be replicating.

subsynccommit

text

Contains the value of the synchronous_commit setting for the subscription workers.

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

subpublications

text[]

Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 31.1.

Prev	Up	Next
52.51. `pg_statistic_ext`	Home	52.53. `pg_subscription_rel`

52.51. pg_statistic_ext

Home

52.53. pg_subscription_rel

PostgreSQL

52.52. pg_subscription

52.52. `pg_subscription`