PG_SUBSCRIPTION v18
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.
| Name | Type | Description |
|---|---|---|
| subpasswordrequired | Boolean | Specifies whether the connection requires a password |
| subrunasowner | Boolean | Specifies whether replication runs as the subscription owner |