pg_subscription_rel
The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping. This catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION ... REFRESH PUBLICATION.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- srsubid, srrelid, srsubstate, srsublsn
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping. This catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION ... REFRESH PUBLICATION.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| srsubid | oid | Not null | Reference to subscription |
| srrelid | oid | Not null | Reference to relation |
| srsubstate | char | Not null | State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication) |
| srsublsn | pg_lsn | Nullable | Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:b8215bebb4d7387ee0555cd59fac9c95ea53281388631f3a96e7112d8de4656b
Text language: en · catalog-bilingual-repair:b8215bebb4d7387ee0555cd59fac9c95ea53281388631f3a96e7112d8de4656b