Re: Classes of returned rows

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