streaming access to bytea data

Hi all,

I've got a couple questions regarding bytea columns and streaming.

1 - Does Postgres server load the entire bytea column before sending to
clients?

Might not be the right list for the previous question, but I thought
someone might know.

2 - Does the current postgres jdbc driver support streaming reads/writes
of bytea columns?  I saw in the archives that someone submitted a patch
for streaming writes, but I didn't see anything regarding reads.

If the jdbc driver doesn't currently support streaming reads, are there
any plans to add this feature?  Any particular technical hurdles?

Thanks,


Dave