PG_SUBSCRIPTION v16

The PG_SUBSCRIPTION view provides information about all existing logical replication subscriptions.

In addition to the information in the PostgreSQL pg_subscription description, EDB Postgres Advanced Server provides the following information.

NameTypeDescription
subpasswordrequiredBooleanSpecifies whether the connection requires a password
subrunasownerBooleanSpecifies whether replication runs as the subscription owner