Re: looking up field names

try

SELECT count(1)
FROM pg_class c, pg_attribute a
WHERE c.relname = '<table to check>'
AND a.attrelid = c.oid
AND a.attname = '<column to check>'

hth

Robert Treat

On Fri, 2002-07-12 at 16:42, terry(at)greatgulfhomes(dot)com wrote:
> I am building a custom field engine. But I want to stop the user from
> creating custom fields of the same name as a standard field in the table.
>
> Would this suffice to find if a column already existed in a table:
>
> SELECT count(*)
> FROM pg_attribute, pg_class
> WHERE pg_class.relname = '<table to check>'
> AND pg_class.reltype = pg_attribute.attrelid
> AND pg_attribute.attname = '<column name to check>'
>
> Thanks in advance
>
> Terry Fielder
> Network Engineer
> Great Gulf Homes / Ashton Woods Homes
> terry(at)greatgulfhomes(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org