Quote:
|
Originally Posted by zalew
hi. in postgres you can't so easily change column type.. the documentation of 'alter table' there's no word about changing column type, as if they didn't want to talk about it 
for a long time i thought it was only possible by recreating the table, but i found something like this in the faq |
This works well, but remeber to add a line to rename new_col to old_col.
The new col now renamed to old_col will appear at the end of the list of fields in the table definition.