Re: add column if doesn't exist

p == peter_e(at)gmx(dot)net writes:

p> Brandon Metcalf wrote:
p> > Is there a way to check for the existence of a column in a table
p> > other than, say, doing a SELECT on that column name and checking the
p> > 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