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@sympatico.ca <mailto:fbax@sympatico.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@postgresql.org
>     <mailto:pgsql-novice@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/__mailpref/pgsql-novice
>     <http://www.postgresql.org/mailpref/pgsql-novice>
>
>