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.