PG_SUBSCRIPTION

PG_SUBSCRIPTION contains all existing logical replication subscriptions. This system catalog is accessible only to system administrators.

Unlike most system catalogs, PG_SUBSCRIPTION is shared across all databases in a cluster. Each cluster has only one copy of PG_SUBSCRIPTION, not one copy per database.

**Table 1** PG_SUBSCRIPTION columns
Name	Type	Description
oid	oid	Row identifier (hidden attribute, which must be specified).
subdbid	oid	OID of the database where the subscription is located
subname	name	Subscription name
subowner	oid	Subscription owner
subenabled	boolean	If the value is true, the subscription is enabled and should be replicated.
subconninfo	text	Information about the connection to the publisher database
subslotname	name	Name of the replication slot in the publisher database If this parameter is left empty, the value is NONE.
subsynccommit	text	Value of synchronous_commit of the subscription worker
subpublications	text[]	Array containing names of subscribed publications. These are publications referenced from the publisher server.