On 9/7/07, SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to