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.