> 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?
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
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.
Oratrix Development BV
GRiNS SMIL Editor
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -