pg_partition_ancestors ( regclass ) → setof regclassLists the ancestor relations of the given partition, including the relation itself. Returns no rows if the relation does not exist or is not a partition or partitioned table.
FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS
pg_partition_ancestors
Read PG 18 manual ↗Lists the ancestor relations of the given partition, including the relation itself.
Signatures & examples
Version history 2
- PG 12 → 13changed
- PG 11 → 12added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source