Re: [Pypgsql-users] Inserting BYTEA values

[Dietmar S. <mai...@sc...>]

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.

Hello Sidney,

I'm storing compressed strings as binary data in PostgreSQL. For me 
PgBytea(data) is working to convert the data into an argument suitable 
for pyPgSQL.
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.


Regards,

Dietmar