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!