50.52. pg_subscription
The catalog pg_subscription contains all existing logical replication subscriptions. For more information about logical replication see Chapter 29.
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 50.52. pg_subscription Columns
Column Type Description |
|---|
Row identifier |
OID of the database which the subscription resides in |
Name of the subscription |
Owner of the subscription |
If true, the subscription is enabled and should be replicating. |
Connection string to the upstream database |
Name of the replication slot in the upstream database (also used for the local replication origin name); null represents |
Contains the value of the |
Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 29.1. |
