pg_subscription_rel

A system table containing the state for each replicated relation in a 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.

Definition by PostgreSQL version

pg_subscription_rel (PostgreSQL 15)

        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 |           |          | 
Indexes:
    "pg_subscription_rel_srrelid_srsubid_index" PRIMARY KEY, btree (srrelid, srsubid)
    

Documentation: pg_subscription_rel

pg_subscription_rel (PostgreSQL 14)

        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 |           |          | 
Indexes:
    "pg_subscription_rel_srrelid_srsubid_index" PRIMARY KEY, btree (srrelid, srsubid)
    

Documentation: pg_subscription_rel

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