From: | "D(dot) Duccini" <duccini(at)backpack(dot)com> |
---|---|
To: | Ryan Ho <ryanho(at)pacific(dot)net(dot)sg> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Maximum size before having to use BLOBs. |
Date: | 2000-06-15 13:25:41 |
Message-ID: | Pine.GSO.4.03.10006150825010.12622-100000@ra.bpsi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
duccini=> create table test (mail varchar(8192));
ERROR: length for type 'varchar' cannot exceed 8088
duccini=>
the answer would be 8088
-duck
On Thu, 15 Jun 2000, Ryan Ho wrote:
> Hi,
>
> What is the maximum size 'text' or 'varchar' can support before a BLOB has to be
> used. I need to store some small text files and I don't know how big is too big
> for a 'varchar'.
>
> Thanks in advance
> Ryan
>
-----------------------------------------------------------------------------
david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | D. Duccini | 2000-06-15 14:24:25 | Re: find the number of row for each tables |
Previous Message | D. Duccini | 2000-06-15 13:23:52 | Re: find the number of row for each tables |