pg_inherits

A system catalogue table storing information about table inheritance hierarchies

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

Definition by PostgreSQL version

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 been part of PostgreSQL since at least PostgreSQL 6.0 and has never been altered.

Categories

DDL, System catalogue