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