As great as postgresql is, there are little things that you wish could be easier to do. On version 7 of Postgresql, changing some of the column attributes meant that you had to either dump, modify and restore or drop a column and recreate it.
It's because there is no straight forward sql statement to do it. I found this hack that shows you how to resize a varchar column.
No comments:
Post a Comment