On Sun, Nov 18, 2012 at 2:29 AM, Tom Lane <t...@sss.pgh.pa.us> 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.