> i would like to alter the column type which has exist in > the table, i can't find anything about that, can anybody help me? To effectively alter the type of a column, you must do a "create table"/"insert into"/"create table as" combination to make an intermediate temporary table with the correct type (of course, other permutations of commands can give the desired result also). - Thomas
- [HACKERS] alter the column type anson
- Thomas Lockhart