Re: Difference between varchar and text?

On 11/17/12 11:48 PM, Abel Abraham Camarillo Ojeda wrote:
> As far as I know varchar(n) with n being less or equal than 126 cannot be
> toasted, and have only one octet of overhead.
>
> http://www.postgresql.org/docs/9.2/static/storage-toast.html

the same is true for varchar(n) with larger values of N as long as the
actual string in the field is under 126 characeters, and the same is
true for text if the actual string is under 126 characters.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast