Conditional ALTER TABLE - Mailing list pgsql-novice

From Dale Seaburg
Subject Conditional ALTER TABLE
Date
Msg-id E6A569AE-7056-4CD9-9CF3-C85FDC1AA2AC@verizon.net
Whole thread Raw
Responses Re: Conditional ALTER TABLE
List pgsql-novice
Is there a way to make a conditional ALTER TABLE command?

If I want to drop a column only if that table's column exists, what
would be the correct syntax.  I have tried several IF EXISTS, but I
get an error at "IF".  I would like to use the Query tool in pgAdmin
III, if possible.  But, if push comes to shove, I'll resort to psql.

As an alternative, how best to tell SQL (Query tool) to continue
processing a script even if an "error" (like no column exists) is
encountered.

Thanks,

Dale

pgsql-novice by date:

Previous
From: Ron Arts
Date:
Subject: Re: I don't understand this explain output
Next
From: Tom Lane
Date:
Subject: Re: Conditional ALTER TABLE