Re: Re : Am I overseen ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Re : Am I overseen ?
Date
Msg-id 27482.1192736143@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re : Am I overseen ?  (Lothar Behrens <lothar.behrens@lollisoft.de>)
List pgsql-general
Lothar Behrens <lothar.behrens@lollisoft.de> writes:
> When there is a way to optionally add columns to existing tables via
> SQL I have very less development needs to get this working.

Why don't you just issue the ALTER ADD COLUMN and ignore the error
if it's duplicate column?

Or if you don't like that, it's not that hard to look into the system
catalogs and see if the column already exists.  A program bright enough
to be issuing dynamic DDL commands ought to be able to do that ...

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Abbreviation list
Next
From: "Tomi N/A"
Date:
Subject: Re: a failover scenario