Re: Newbie Question

From: Richard Poole <richard(dot)poole(at)vi(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Cc: John Pilley <jpilley(at)spescrow(dot)com>
Subject: Re: Newbie Question
Date: 2000-11-01 18:00:37
Message-ID: 20001101180037.O21112@office.vi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 01, 2000 at 12:32:58PM -0500, Nick Fankhauser wrote:
> According to the documentation and Bruce M's book, there is no limit. I've
> never hit a limit while putting some pretty large (three page) narratives in
> a text field.

There is no limit on the "text" type as such, but there is still the limit
on the total size of a row: about 8k by default, 32k if you're willing
to recompile (see the FAQ). This limit will be removed entirely by TOAST
in 7.1 .

Richard

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Henry Davie 2000-11-01 18:01:09 Re: Hardwood Website
Previous Message Wade D. Oberpriller 2000-11-01 17:53:29 Re: Increasing Table Column Size in 7.0 Syntax