Re: Max String length? - Mailing list pgsql-general

From John Gray
Subject Re: Max String length?
Date
Msg-id bajknn$2ees$1@news.hub.org
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] Q: Structured index - which one runs faster?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM and transaction ID wraparound