getting inherited table name - Mailing list pgsql-general

From Eric Kolve
Subject getting inherited table name
Date
Msg-id 3B9765A5.ED5A5DC@corp.classmates.com
Whole thread Raw
Responses Re: getting inherited table name
List pgsql-general
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

pgsql-general by date:

Previous
From: Rob Brown-Bayliss
Date:
Subject: Primary keys and speed
Next
From: Andrew Gould
Date:
Subject: template0 and template1 databases