Sidney Cadot wrote:
> On Mar 9, 2009, at 18:36, Clarence Gardner (ADECN) wrote:
>> I don't know the details off the top of my head (it's been a couple
>> of years), but I recall there's a Binary class somewhere (possibly
>> in pypgsql, possible in a standard library) that you can wrap those
>> things in.
> Well, there's PgSQL.PgBytea, but I haven't been able to use to solve
> my particular problem, unfortunately. I have a feeling it /should/
> work, but it doesn't.
I'm storing compressed strings as binary data in PostgreSQL. For me
PgBytea(data) is working to convert the data into an argument suitable
I can't show the SQL code, as I'm using a wrapper, but I don't
remember doing anything special.
I'm using named parameters and a dictionary for the data.
The revisions are 2.5.1 for Python and pyPgSQL.