Search Postgresql Archives

Re: Re : Am I overseen ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Lothar Behrens <lothar.behrens@xxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux