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

## 51.54. `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.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` |  | Remote LSN of the state change used for synchronization coordination when in `s` or `r` states, otherwise null

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