Re: conditional alter table add ? - Mailing list pgsql-general

From Peter Childs
Subject Re: conditional alter table add ?
Date
Msg-id a2de01dd0710250415y4b96decfwdb7f0006d81c149e@mail.gmail.com
Whole thread Raw
In response to conditional alter table add ?  (Lothar Behrens <lothar.behrens@lollisoft.de>)
List pgsql-general


On 17/10/2007, Lothar Behrens <lothar.behrens@lollisoft.de> wrote:
Hi,

I do convert an UML XMI model to a database script to create the
database schema.
To enable multiple iterations I need conditional alter table add
column like syntax.

Is there any way to do this ?


Not easily in a straight forward sql script. your going to need to write your script in a scripting language (like perl, python or ruby) then do the alter table query dependent
on other queries to the database,

Peter.

pgsql-general by date:

Previous
From: Garry Saddington
Date:
Subject: execute pg_dump via python
Next
From: Gregory Stark
Date:
Subject: Re: [PGSQL v8.2.5] Similar queries behave differently