Re: Classes of returned rows

<quote who="will trillich">

> 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;

select pg_class.relname, *
from users
where pg_class.relfilenode = tableoid;

relname | login | passhash
-----------+----------+----------
users | user | user
users | user2 | user2
clients | client | client
clients | client2 | client2
suppliers | supplier | supplier

Results from 7.1 :)

- Jeff

--
Web development with PHP is like injecting pure rust with a
high-pressure hose. For pain relief.