Re: looking up field names
От | Robert Treat |
---|---|
Тема | Re: looking up field names |
Дата | |
Msg-id | 1026514022.5293.22.camel@camel обсуждение исходный текст |
Ответ на | looking up field names (terry@greatgulfhomes.com) |
Список | pgsql-general |
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@greatgulfhomes.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@greatgulfhomes.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-general по дате отправления: