Re: CLOB support in postgresql - Mailing list pgsql-general

From Scott Marlowe
Subject Re: CLOB support in postgresql
Date
Msg-id dcc563d10709071852q5f0d9257tdfe01ed515e90998@mail.gmail.com
Whole thread Raw
In response to CLOB support in postgresql  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
On 9/7/07, SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com> wrote:
> What is the best way to store clob data in postgresql?
> Currently I store my clob data as a text. The data consists of large xml
> files. When I access the text field using getString method in jdbc, the
> program is not able to hold a huge string in memory .If I can stream this
> data  to and from the database it will be good. Is there a way to do this?
> Are there any other solution to this problem?

Look into large objects.  they stream.

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Left joining table to setof function
Next
From: Tom Lane
Date:
Subject: Re: Left joining table to setof function