System Catalogs / System catalogs
pg_inherits
Read the PG 18 manualThe catalog pg_inherits records information about table and index inheritance hierarchies.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
inhrelid | oidNOT NULL | The OID of the child table or index pg_class.oid |
inhparent | oidNOT NULL | The OID of the parent table or index pg_class.oid |
inhseqno | int4NOT NULL | If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1. Indexes cannot have multiple inheritance, since they can only inherit when using declarative partitioning. |
inhdetachpending | boolNOT NULL | true for a partition that is in the process of being detached; false otherwise. |
Column history across versions
Version history 6
Definition snapshot: english-manuals:8960c6d156409eada07caa929fd… · English manual source