This page in other versions: current (10)  |  Development versions: devel / 11

52.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 52.53. pg_subscription_rel Columns

Name Type References Description
srsubid oid pg_subscription.oid Reference to subscription
srrelid oid pg_class.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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group