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 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, and has never been modified.
References
- PostgreSQL documentation: pg_inherits