System Catalogs / System catalogs
pg_subscription_rel
Read the PG 18 manualThe catalog pg_subscription_rel contains the state for each replicated relation in each subscription.
Reading PG 18current·documented in 11 of 24 versions, 10 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
srsubid | oidNOT NULL | Reference to subscription pg_subscription.oid |
srrelid | oidNOT NULL | Reference to relation pg_class.oid |
srsubstate | charNOT NULL | State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication) |
srsublsn | pg_lsn | Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null |
Column history across versions
Definition snapshot: english-manuals:d60d3256d3581ba8337460aea26… · English manual source