Re: Using a psycopg2 converter to retrieve bytea data from PostgreSQL - Mailing list psycopg

From Andy Casey
Subject Re: Using a psycopg2 converter to retrieve bytea data from PostgreSQL
Date
Msg-id 71DB388E-5985-4978-878B-7B921A34FEEA@gmail.com
Whole thread Raw
In response to Re: Using a psycopg2 converter to retrieve bytea data from PostgreSQL  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List psycopg
Hi,

I'm just re-raising this problem to anyone on the mailing list, because I haven't had any luck on StackOverflow, or any suggested answers from the mailing list:


With thanks,
Andy

On 11/05/2012, at 7:43 AM, Daniele Varrazzo wrote:


On May 10, 2012 11:18 PM, "Andy Casey" <andycasey@gmail.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


psycopg by date:

Previous
From: Andy Casey
Date:
Subject: Re: Using a psycopg2 converter to retrieve bytea data from PostgreSQL
Next
From: "W. Matthew Wilson"
Date:
Subject: How do I use parameterized queries with LIKE?