On Sun, Nov 18, 2012 at 2:29 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
I'd generally recommend using "text" if you don't have any interest in
enforcing a specific length limit.
Will there be any table re-writing if I do an alter to change the column type from varchar(N) to text? I have some really old (from 2000 and 2001) schemas that have a metric boatload of data in them, and I'd like to remove the old artificial limit on them.