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@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!