Re: [GENERAL] varchar vs Text & TOAST

2008-09-07 Thread Craig Ringer
Ow Mun Heng wrote: Anyhow, searching the archives (in my mail client - no internet at the moment), I see references that when I use TEXT, I will create TOAST tables which will have them lie _outside_ of my main data table. The same is true of varchar, and quite a few other data types. There's

[GENERAL] varchar vs Text & TOAST

2008-09-07 Thread Ow Mun Heng
Hi, I'm a (more than a) bit confuse as to the diference between TEXT and varchar data-types. AFAIK, varchar will have a max limit char of, if not mistaken ~65k? But for TEXT, it's more like a BLOB and there's supposed to be no limit? Anyhow, searching the archives (in my mail client - no interne