Re: add column if doesn't exist

p == peter_e@gmx.net writes:
p> Brandon Metcalf wrote:p> > Is there a way to check for the existence of a column in a tablep> > other than, say,
doinga SELECT on that column name and checking thep> > output?
 
p> SELECT * FROM information_schema.columns;
p> Customize to taste.


Yes, that's what I'm looking for.  Thanks.

Now, is there a way to mix PostgreSQL commands and SQL and do
something like
 ALTER TABLE foo ADD COLUMN bar WHERE EXISTS(SELECT * FROM   information_schema.columns WHERE ...)

?

-- 
Brandon