Re: Using a psycopg2 converter to retrieve bytea data from PostgreSQL

On May 10, 2012 11:18 PM, "Andy Casey" <andycasey(at)gmail(dot)com> wrote:
>
> Hi there,
>
> I have used psycopg2's adapters and converters in the past with numeric[]
arrays in PostgreSQL, and now I'm trying to use them with binary data types
(bytea). I've outlined my problem in detail with some test code which
illustrates what works (without adapters/converters), and how it fails when
I build my working code into using an adapter and converter:
>
>
http://stackoverflow.com/questions/10529351/using-a-psycopg2-converter-to-retrieve-bytea-data-from-postgresql
>
> Would you mind taking a look and providing some advice?
>
> Thanks,
> Andy

As answered on SO:

"""
The format you see in the debugger is easy to parse: it is PostgreSQL hex
binary format (
http://www.postgresql.org/docs/9.1/static/datatype-binary.html). psycopg
can parse that format and return a buffer containing the data; you can use
that buffer to obtain an array. Instead of writing a typecaster from
scratch, write one invoking the original func and postprocess its result.
Sorry but I can't remember its name now and I'm writing from a mobile: you
may get further help from the mailing list.
"""

I think you are close to the solution of your case: please keep us informed!

-- Daniele