[Zope] ZSQL question

Paul Zwarts paul.zwarts@oratrix.com
Tue, 17 Oct 2000 17:39:07 +0200


> I have a table with lots of data in my Gadfly database. I would like to add
> a couple of new columns to that table. Is it at all possible to add columns
> to existing table or do I have to create a new table all together?
>

Nope,

ALTER  TABLE <TABLE_NAME> ADD <COLUMN_NAME> <FORMAT_TYPE>
i think should do it... Let me check

ALTER TABLE memberlist ADD name VARCHAR

Yep... that does it. Although I had tested this in PGSQL, Im sure it works for
GadFly also.

Since you are also inserting a new column you may want to initialize all
current reocrds with a value, but I cant remember what it was... If you really
need it, let me know, I'll dig in for you.

Cheers,

--
Paz
Oratrix Development BV
http://www.oratrix.com
GRiNS SMIL Editor
-