streaming bytea: is it possible ? - Mailing list pgsql-jdbc

From Csaba Nagy
Subject streaming bytea: is it possible ?
Date
Msg-id 1153845453.22367.41.camel@coppola.muc.ecircle.de
Whole thread Raw
Responses Re: streaming bytea: is it possible ?
List pgsql-jdbc
Hi all,

I wonder if it is possible to stream bytea fields without reading them
completely in memory ?

The reason I want that is because I want to use slony1 to replicate some
tables containing BLOBs, and slony can't handle BLOBs. So I would like
to convert the BLOBs to bytea (which can be handled properly by slony1),
but I can't afford to load the complete BLOBs in memory, I only need to
stream them. Now I wonder if the postgres JDBC implementation/postgres
server is capable of doing that, or any of them needs to have the
complete bytea in memory at one point...

Of course I could check the source but if any of you knows it offhand I
would appreciate an answer.

Thanks,
Csaba.



pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Invalid column display size. Cannot be less than zero
Next
From: Kris Jurka
Date:
Subject: Re: streaming bytea: is it possible ?