Re: Clarification question

Just a note... In order to get your suggestion to work I had to alter it
slightly:

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

Without the alias I get a "Column reference oid is ambiguous" error.

Tim Barnard
S.E. Mgr
Hartford Communications Corporation

----- Original Message -----
From: "Tommi Mäkitalo" <t(dot)maekitalo(at)epgmbh(dot)de>
To: "Tim Barnard" <tbarnard(at)povn(dot)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
> >>
>
>
>