Are you an LLM? You can read better optimized documentation at /en/docs/latest/database_reference/pg_subscription_rel.md for this page in Markdown format
PG_SUBSCRIPTION_REL
The system catalog PG_SUBSCRIPTION_REL contains the status of each replicated table in each subscription. It is a many-to-many mapping.
This system catalog contains only tables known to the subscription after running CREATE SUBSCRIPTION or ALTER SUBSCRIPTION... REFRESH PUBLICATION.
Table 1 PG_SUBSCRIPTION_REL columns
Name | Type | Description |
|---|
srsubid | oid | Identifier of the subscription. |
srrelid | oid | Subscription relationship ID. |
srsubstate | char | Subscription status. i: Initialization.d: Basic data being replicated.f: Basic data replication completed.s: Progress synchronized with incremental replication.r: Incremental replication ready. |
srcsn | int8 | Snapshot CSN during basic data replication. |
srsublsn | text | Remote LSN used to synchronize the incremental replication progress in the s or r state. Otherwise, the value is null. |