Re: getting inherited table name - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: getting inherited table name
Date
Msg-id Pine.LNX.4.30.0109061507340.823-100000@peter.localdomain
Whole thread Raw
In response to getting inherited table name  (Eric Kolve <ekolve@corp.classmates.com>)
List pgsql-general
Eric Kolve writes:

> 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'?

There's an otherwise hidden column called "tableoid" that contains the oid
of the table the row really came from.  You can join that against pg_class
to get the name of the table.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: template0 and template1 databases
Next
From: David Wheeler
Date:
Subject: Re: Bug in createlang?