> 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
-



_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to