On Sun, Nov 18, 2012 at 2:29 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.