51.54. pg_subscription_rel

51.54. `pg_subscription_rel`
Prev	Up	Chapter 51. System Catalogs	Home	Next

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.54. 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.

Prev	Up	Next
51.53. `pg_subscription`	Home	51.55. `pg_tablespace`