Currently, what I did is like
. alter table test add column machineIDnew varchar;
. update test set machineIDnew = machineID;
. alter table test rename machineIDnew to machineID;
. vacuum full table;
If better ways, please let me know.
Thanks a lot,
Greg Donald wrote:
On Tue, 14 Sep 2004 13:33:32 -0700, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
You can not currently change the data type with alter table.
Are there any plans to add this functionality?
What's the best workaround? Add a new column, copy data from old
column to new column, drop old column?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
