Re: [SQL] Finding the names of inheriting classes

2000-06-28 Thread Thomas Swan
Thanks... At the same time I had a friend guide me through the system tables... :) - - Thomas Swan - - Graduate Student  - Computer Science - The University of Mississippi - - "People can be sorted into two fundamental groups, - those that divide peo

Re: [SQL] Finding the names of inheriting classes

2000-06-28 Thread Tom Lane
Thomas Swan <[EMAIL PROTECTED]> writes: > I'm at a loss on how identify or get the names of children of a parent class. Join pg_class against pg_inherits. regards, tom lane

[SQL] Finding the names of inheriting classes

2000-06-28 Thread Thomas Swan
This is actually two problems... I'm at a loss on how identify or get the names of children of a parent class. For example, I have three children of a parent class Cities : Big_Cities, Little_Cities, Not_Cities.   I know that I can do a select * from Cities* and get all rows from Cities and Citi