On 9/7/07, SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx> 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
