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
><jd(at)commandprompt(dot)com> 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?
>
>
>
>