pg_inherits
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
- PostgreSQL 14
- column
inhdetachpending
added (commit 71f4c8c6)
- column
pg_inherits
has always been present in PostgreSQL.
References
- PostgreSQL documentation: pg_inherits