51.53. 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
.
Table 51.53.
pg_subscription_rel
Columns
| Name | Type | References | Description |
|---|---|---|---|
srsubid
|
oid
|
|
Reference to subscription |
srrelid
|
oid
|
|
Reference to relation |
srsubstate
|
char
|
State code:
i
= initialize,
d
= data is being copied,
s
= synchronized,
r
= ready (normal replication)
|
|
srsublsn
|
pg_lsn
|
End LSN for
s
and
r
states.
|