Re: Classes of returned rows

On Thu, Apr 26, 2001 at 05:39:43PM +0200, Peter Eisentraut wrote:
> Jeff Waugh writes:
>
> > Is there a way of determining the original class of a row when querying
> > inherited tables?
>
> Use the implicit tableoid column.

okay, all i get from

select c.relname,a.attname
from pg_class c,pg_attribute a
where a.attrelid=c.oid
AND a.attname LIKE 'table%'
order by attname,relname;

is

relname | attname
------------+------------
pg_indexes | tablename
pg_rules | tablename
pg_tables | tablename
pg_tables | tableowner

cmax, xmin and oid show up, but no tableoid.

is it a 7.1 thing? i'm using 7.0.3...

--

and anybody care to enlighten a greenhorn as to
where xmax/xmin and cmax/cmin come in useful?

--
don't visit this page. it's bad for you. take my expert word for it.
http://www.salon.com/people/col/pagl/2001/03/21/spring/index1.html

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!