Re: Max String length?

From: "John Gray" <jgray(at)azuli(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Max String length?
Date: 2003-05-22 22:56:53
Message-ID: bajknn$2ees$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 21 May 2003 04:43:47 +0000, james wrote:

> I am inserting chunks of text into a postgresql database. I was
> wondering if there is a limit on the size of the length on the string
> I can insert and what it is.
>

The limit is 1GB - 4 bytes (assuming modern versions of PostgreSQL).

> What are my options to overcome this limitation?

You would have to split your string into smaller chunks for storage - or
not store it in the DB.

>
> Cheers,
>
> james

Regards

John

--

John Gray

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-05-22 23:00:54 Re: [ADMIN] Q: Structured index - which one runs faster?
Previous Message Tom Lane 2003-05-22 22:53:00 Re: Q: Structured index - which one runs faster?