Viswamitra's blog

To find the child tables of a partitioned table in PostgreSQL 14 use the below query.

select relname as table_name
from pg_class join pg_inherits on (pg_class.oid=pg_inherits.inhrelid and relkind='r')
where inhparent in (select oid from pg_class where relname='<parent_table_name>');