Re: Retrieving binary data

On Fri, 05 Jul 2002 12:12:45 -0700
Barry Lind <barry(at)xythos(dot)com> wrote:

> David,
>
> If I understand what you are trying to do correctly, using a binary
> cursor should solve your problem. See the docs on the "declare [binary]
> cursor" SQL command.

First, thanks for your anwser.
Yeah that's exactly what I'm thinking, but will it work with JDBC? I guess I can execute several queries in a row with declare and fetch, but will it send me the correct bytes? I'm open to any suggestion (including Fastpath or another JDBC driver).

Best Regards,
David Garnier

> David Garnier wrote:
>
> >Hello,
> >
> >I need to retrieve the binary representation of a custom type. I can retrieve the type just fine with the standard method, but the results of getBytes is altered. getString shows just the right thing, but I need the binary. I looked at the source of the driver, and I still don't know exactly what I'm supposed to do. It seems to me that the QueryExecutor is able to fetch a binary tuple, but I don't know how to request one.
> >
> >Performance is my main problem, so I would like a fast solution. Thanks for helping.
> >
> >Best regards,
> >David Garnier
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 6: Have you searched our list archives?
> >
> >http://archives.postgresql.org
> >
> >
> >
> >
> >
>
>
>