Re: Cannot Retrieve Binary Data

patrick wrote:

> There's no way to stream a bytea ? how postgres support bytea with 1G if
> is not possible to insert and select ?

You need to use the binary parameter/result format (at the protocol
level). The current JDBC driver uses the binary format for bytea
parameters, but the text format for resultsets. psql uses the text
format for both, I believe.

> FYI:
> i tried the same Test with postgres 7.4.7 and earlier and is even worst
>  i was not able to insert.
> The  JDBC Driver  Return Out_Of_Memory during the query execution

I assume you mean with an earlier version of the driver? Earlier driver
versions used the text format for both parameters and results, and also
used a large amount of temporary heap space for large bytea parameters.

You may want to look at using the large-object interface if you are
dealing with extremely large data; it allows random read/write access to
the data without transferring it all across the wire in one go.

-O