Re: Classes of returned rows - Mailing list pgsql-general

From will trillich
Subject Re: Classes of returned rows
Date
Msg-id 20010426232632.C21240@serensoft.com
Whole thread Raw
In response to Re: Classes of returned rows  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Classes of returned rows
List pgsql-general
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!

pgsql-general by date:

Previous
From: Chris Smith
Date:
Subject: Re: Report Writer for PostgreSQL
Next
From: will trillich
Date:
Subject: Re: last comma inside "CREATE TABLE ()" statements