CLOB support in postgresql

From: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CLOB support in postgresql
Date: 2007-09-07 13:43:01
Message-ID: 658178.62209.qm@web31112.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?
Thanks in advance
shar joe


---------------------------------
Shape Yahoo! in your own image. Join our Network Research Panel today!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2007-09-07 13:57:36 Case insensitivity problem
Previous Message Richard Huxton 2007-09-07 13:23:34 Re: debuging transactions