Can't you just try to add the column and catch the error? If you're
in a transaction use a user defined function to run it an catch the
exception in pl/pgsql.
On Thu, Jun 5, 2008 at 12:15 PM, Michael P. Soulier
<[EMAIL PROTECTED]> wrote:
> I'm using some simple migration code to execute individua
I'm using some simple migration code to execute individual fragments of
SQL code based on the version of the schema. Is there a way to perform
an ALTER TABLE conditionally?
Example:
I want to add column foo to table bar, but only if column foo does not
exist already.
I'm trying to avoid suc