Re: [GENERAL] getting inherited table name

2001-09-06 Thread Nico
Eric Kolve wrote: > 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

[GENERAL] getting inherited table name

2001-09-06 Thread Eric Kolve
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' t