Friday, August 25, 2006

Postgresql Tip : Resizing Varchar Columns

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.