pg_subscription_rel #
The catalog pg_subscription_rel stores the
state of each replicated table and sequence for each subscription. This
is a many-to-many mapping.
This catalog contains tables and sequences known to the subscription
after running:
CREATE SUBSCRIPTION,
ALTER SUBSCRIPTION ... REFRESH PUBLICATION, or
ALTER SUBSCRIPTION ... REFRESH SEQUENCES.
Table 52.55. pg_subscription_rel Columns
Column Type Description |
|---|
Reference to subscription |
Reference to table or sequence |
State code for the table or sequence.
State codes for tables:
State codes for sequences:
|
Remote LSN of the state change used for synchronization coordination
when in |