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.
|Row identifier (hidden attribute; must be explicitly selected)|
|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.|
| Contains the value of the |
|Connection string to the upstream database|
|Name of the replication slot in the upstream database. Also used for local replication origin name.|
|Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 31.1.|