Thanks for the suggestion.
Tim Barnard
S.E. Mgr
Hartford Communications Corporation
----- Original Message -----
From: "Tommi Mäkitalo" <t.maekitalo@epgmbh.de>
To: "Tim Barnard" <tbarnard@povn.com>
Sent: Sunday, January 20, 2002 10:53 AM
Subject: Re: [GENERAL] Clarification question
> Hi,
>
> You could use a join too. It will be simpler to optimize it:
>
> select attname
> from pg_attribute join pg_class on attrelid = oid
> where relname = '<insert table name here>'
> and attnum > 0
>
> Tommi
>
> ...
>
> >>>select attname from pg_attribute
> >>> where attrelid=
> >>> (select relfilenode from pg_class
> >>> where relname like <insert table name here>)
> >>> and attnum > 0
> >>>
> ...
>
> >>
> >>select attname from pg_attribute
> >> where attrelid=
> >> (select oid from pg_class
> >> where relname = '<insert table name here>')
> >> and attnum > 0
> >>
>
>
>