PostgreSQL: Displaying inheritance relationship?

Question

I want to know if a certain PostgreSQL table is a part of any inheritance relationship (i.e. is a parent or a child of other table(s)).

Is there a query for that? Where is the inheritance data stored?

Adam Matan · Accepted Answer · 2011-06-02 11:35:02Z

up vote 5 down vote accepted

SELECT relname 
FROM pg_class c,pg_inherits i 
WHERE c.oid=i.inhrelid;

I am the guy that asked Adam about this, I found a solution so I added it here for future reference of others.

edited Jun 2 '11 at 11:35

Adam Matan
730929

answered Jun 2 '11 at 11:26

David Kohen
1863

Caleb · Answer 2 · 2011-06-02 10:56:47Z

up vote 3 down vote

answered Jun 2 '11 at 10:56

Caleb
49835

2 Answers