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 )