Re: How To Store Large Text Strings

Hi,
It is not really unlimited (max 1GB):

*Limit* *Value*Maximum Database SizeUnlimitedMaximum Table Size32 TBMaximum
Row Size 1.6 TB*Maximum Field Size**1 GB*Maximum Rows per TableUnlimitedMaximum
Columns per Table250 - 1600 depending on column types Maximum Indexes per
TableUnlimited
http://www.postgresql.org/about/

Regards,
Bartek

2012/3/9 Frank Bax <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)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-novice<http://www.postgresql.org/mailpref/pgsql-novice>
>