Re: streaming access to bytea data

Kris Jurka wrote:
> On Fri, 17 Mar 2006, David Durham wrote:
>
>> 1 - Does Postgres server load the entire bytea column before sending
>> to clients?
>
> Yes.

ok

> The JDBC driver doesn't support streaming reads, nor does any other
> client interface. You would need to extend the frontend/backend
> protocol to return some sort of pointer to the bytea reference rather
> than the whole thing. This will still require the server to store the
> whole bytea result somewhere to allow it to be pointed to.
>
> Perhaps you should think about using large objects instead of bytea?

Thanks for the quick response, and the exact information that I needed.
Unfortunately large objects don't work with Slony replication.

Thanks again,

Dave