Contents

pg_inherits

A system table storing information about table inheritance

pg_inherits is a system catalogue table storing information about table inheritance hierarchies.

pg_inherits has always been present in PostgreSQL.

Definition by PostgreSQL version

pg_inherits (PostgreSQL 16)

               Table "pg_catalog.pg_inherits"
      Column      |  Type   | Collation | Nullable | Default 
------------------+---------+-----------+----------+---------
 inhrelid         | oid     |           | not null | 
 inhparent        | oid     |           | not null | 
 inhseqno         | integer |           | not null | 
 inhdetachpending | boolean |           | not null | 
Indexes:
    "pg_inherits_relid_seqno_index" PRIMARY KEY, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 15)

               Table "pg_catalog.pg_inherits"
      Column      |  Type   | Collation | Nullable | Default 
------------------+---------+-----------+----------+---------
 inhrelid         | oid     |           | not null | 
 inhparent        | oid     |           | not null | 
 inhseqno         | integer |           | not null | 
 inhdetachpending | boolean |           | not null | 
Indexes:
    "pg_inherits_relid_seqno_index" PRIMARY KEY, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 14)

               Table "pg_catalog.pg_inherits"
      Column      |  Type   | Collation | Nullable | Default 
------------------+---------+-----------+----------+---------
 inhrelid         | oid     |           | not null | 
 inhparent        | oid     |           | not null | 
 inhseqno         | integer |           | not null | 
 inhdetachpending | boolean |           | not null | 
Indexes:
    "pg_inherits_relid_seqno_index" PRIMARY KEY, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 13)

            Table "pg_catalog.pg_inherits"
  Column   |  Type   | Collation | Nullable | Default 
-----------+---------+-----------+----------+---------
 inhrelid  | oid     |           | not null | 
 inhparent | oid     |           | not null | 
 inhseqno  | integer |           | not null | 
Indexes:
    "pg_inherits_parent_index" btree (inhparent)
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)

Documentation: pg_inherits

pg_inherits (PostgreSQL 12)

            Table "pg_catalog.pg_inherits"
  Column   |  Type   | Collation | Nullable | Default 
-----------+---------+-----------+----------+---------
 inhrelid  | oid     |           | not null | 
 inhparent | oid     |           | not null | 
 inhseqno  | integer |           | not null | 
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 11)

            Table "pg_catalog.pg_inherits"
  Column   |  Type   | Collation | Nullable | Default 
-----------+---------+-----------+----------+---------
 inhrelid  | oid     |           | not null | 
 inhparent | oid     |           | not null | 
 inhseqno  | integer |           | not null | 
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 10)

            Table "pg_catalog.pg_inherits"
  Column   |  Type   | Collation | Nullable | Default 
-----------+---------+-----------+----------+---------
 inhrelid  | oid     |           | not null | 
 inhparent | oid     |           | not null | 
 inhseqno  | integer |           | not null | 
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 9.6)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 9.5)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 9.4)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 9.3)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 9.2)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 9.1)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 9.0)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)
    "pg_inherits_parent_index" btree (inhparent)

Documentation: pg_inherits

pg_inherits (PostgreSQL 8.4)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)

Documentation: pg_inherits

pg_inherits (PostgreSQL 8.3)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)

Documentation: pg_inherits

pg_inherits (PostgreSQL 8.2)

 Table "pg_catalog.pg_inherits"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 inhrelid  | oid     | not null
 inhparent | oid     | not null
 inhseqno  | integer | not null
Indexes:
    "pg_inherits_relid_seqno_index" UNIQUE, btree (inhrelid, inhseqno)

Documentation: pg_inherits

Change history

pg_inherits has always been present in PostgreSQL.

Categories

DDL, System catalogue