The pg_inherits catalog provides information about table and index inheritance.
| Column name | Data type | Description |
|---|---|---|
inhrelid |
oid (references pg_class.oid) |
The OID of the child table or index. |
inhparent |
oid (references pg_class.oid) |
The OID of the parent table or index. |
inhseqno |
int4 |
The position of the parent when a table has multiple direct parents (multiple inheritance). The numbering starts at 1.Note: Indexes cannot have multiple inheritance. They may only inherit when used in declarative partitioning. |
inhdetachpending |
bool |
Specifies whether the partition is currently being detached (TRUE) or not (FALSE). |