pg_subscription_rel

A system catalogue table containing the state for each replicated relation in each subscription

pg_subscription_rel is a system catalogue table containing the state for each replicated relation in each subscription.

pg_subscription_rel was added in PostgreSQL 10 (commit 7c4f5240).

Definition by PostgreSQL version

pg_subscription_rel (PostgreSQL 13)

        Table "pg_catalog.pg_subscription_rel"
   Column   |  Type  | Collation | Nullable | Default
------------+--------+-----------+----------+---------
 srsubid    | oid    |           | not null |
 srrelid    | oid    |           | not null |
 srsubstate | "char" |           | not null |
 srsublsn   | pg_lsn |           | not null |
Indexes:
    "pg_subscription_rel_srrelid_srsubid_index" UNIQUE, btree (srrelid, srsubid)
    

Documentation: pg_subscription_rel

pg_subscription_rel (PostgreSQL 12)

        Table "pg_catalog.pg_subscription_rel"
   Column   |  Type  | Collation | Nullable | Default
------------+--------+-----------+----------+---------
 srsubid    | oid    |           | not null |
 srrelid    | oid    |           | not null |
 srsubstate | "char" |           | not null |
 srsublsn   | pg_lsn |           | not null |
Indexes:
    "pg_subscription_rel_srrelid_srsubid_index" UNIQUE, btree (srrelid, srsubid)
    

Documentation: pg_subscription_rel

pg_subscription_rel (PostgreSQL 11)

        Table "pg_catalog.pg_subscription_rel"
   Column   |  Type  | Collation | Nullable | Default
------------+--------+-----------+----------+---------
 srsubid    | oid    |           | not null |
 srrelid    | oid    |           | not null |
 srsubstate | "char" |           | not null |
 srsublsn   | pg_lsn |           | not null |
Indexes:
    "pg_subscription_rel_srrelid_srsubid_index" UNIQUE, btree (srrelid, srsubid)
    

Documentation: pg_subscription_rel

pg_subscription_rel (PostgreSQL 10)

        Table "pg_catalog.pg_subscription_rel"
   Column   |  Type  | Collation | Nullable | Default
------------+--------+-----------+----------+---------
 srsubid    | oid    |           | not null |
 srrelid    | oid    |           | not null |
 srsubstate | "char" |           | not null |
 srsublsn   | pg_lsn |           | not null |
Indexes:
    "pg_subscription_rel_srrelid_srsubid_index" UNIQUE, btree (srrelid, srsubid)
    

Documentation: pg_subscription_rel

Change history

This table has not been modified since it was added in PostgreSQL 10.

Categories

Replication, System catalogue

See also

pg_subscription