Re: Classes of returned rows - Mailing list pgsql-general

From Jeff Waugh
Subject Re: Classes of returned rows
Date
Msg-id 20010427161635.A9569@aphid.net
Whole thread Raw
In response to Re: Classes of returned rows  (will trillich <will@serensoft.com>)
List pgsql-general
<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.

pgsql-general by date:

Previous
From: Anand Raman
Date:
Subject: Re: Data Export from PostGreSQL
Next
From: Eugene Lee
Date:
Subject: COPY syntax in ColdFusion