In the pgsql tutorial two tables are created capitals inherits cities.
When you do SELECT * FROM cities, you get both capitals and cities. Is
there anyway to get get the name of the table so I could possibly know
the 'type' it was? Or should this be maintained as a separate column
'city_type' that has a value of 'capital'?
Suppose I had another table river_cities and what I would want to be
able to is SELECT * FROM cities and know whether the city was a
river_city, capital, or nothing at all.
thanks,
--eric