PG_SUBSCRIPTION

PG_SUBSCRIPTION records all existing subscriptions.

**Table 1** PG_SUBSCRIPTION columns
Column	Type	Reference	Description
OID	OID	-	Row identifier (hidden attribute; displayed only when explicitly selected)
subdbid	OID	PG_DATABASE.oid	OID of the database that the subscription belongs to
subname	Name	-	Name of a subscription
subowner	OID	PG_AUTHID.oid	Owner of a subscription
subenabled	Boolean	-	If it is true, the subscription is enabled and should be replicated.
subconninfo	Text	-	Information about the connection to the database at the publisher end
subslotname	Text	-	Name of the replication slot in the publisher database If this parameter is left blank, the value is NONE.
subpublications	Text[]	-	Array of subscribed publication names. These are the references to the publications on the publisher server.

Examples

View all subscriptions.

     
          SELECT * FROM pg_subscription;
 subdbid | subname | subowner | subenabled |                                       subconninfo                                        | subslotname | subpublications 
---------+---------+----------+------------+------------------------------------------------------------------------------------------+-------------+-----------------
   15992 | mysub   |       10 | t          | host=1.1.1.1,2.2.2.2 port=10000,20000 dbname=postgres user=repusr1 password=password_123 | mysub       | {mypub}
(1 row)