Re: How To Store Large Text Strings

While I agree that max field size is 1G; I quoted "variable unlimited
length" from the postgresql website (see link below).

On 03/09/12 03:02, Bartosz Dmytrak wrote:
> Hi,
> It is not really unlimited (max 1GB):
>
> *Limit* *Value*
> Maximum Database Size Unlimited
> Maximum Table Size 32 TB
> Maximum Row Size 1.6 TB
> _*Maximum Field Size*_ _*1 GB*_
> Maximum Rows per Table Unlimited
> Maximum Columns per Table 250 - 1600 depending on column types
> Maximum Indexes per Table Unlimited
>
>
> http://www.postgresql.org/about/
>
> Regards,
> Bartek
>
>
> 2012/3/9 Frank Bax <fbax(at)sympatico(dot)ca <mailto:fbax(at)sympatico(dot)ca>>
>
> On 03/08/12 17:24, Jude Lucien wrote:
>
> What is the best way to store possible multiple-paragraph-sized
> strings of text?
>
> I had thought of just storing the hash but there is no guarentee
> that
> the hash will pop back into the same text.
>
>
>
> text (variable unlimited length)
>
> http://www.postgresql.org/__docs/9.0/static/datatype-__character.html <http://www.postgresql.org/docs/9.0/static/datatype-character.html>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org
> <mailto:pgsql-novice(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/__mailpref/pgsql-novice
> <http://www.postgresql.org/mailpref/pgsql-novice>
>
>