Re: Clarification question

Make that...

select attname
   from pg_attribute join pg_class p1 on attrelid=p1.oid
   where relname='<insert table name here>'
   and attnum > 0

Sorry for the fat-fingering :-)

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