Find all partition tables "inheriting" from master table

Question

Say I have a table, "foo", with partition tables "foo1", "foo2", and "foo3". But at the current moment all I know is there are parition tables which inherit from table "foo". How can I find that foo has 3 partitions, foo1, foo2, and foo3?

Answer 1

Starting with Postgres 12, there is a built-in function:

select *
from  pg_partition_tree('the_table'::regclass)
where parentrelid is not null;