[Python-Dev] BLOBs in Pg

Sylvain Thénault sylvain.thenault at logilab.fr
Fri Apr 10 09:49:00 CEST 2009

On 09 avril 14:05, Steve Holden wrote:
> Oleg Broytmann wrote:
> > On Thu, Apr 09, 2009 at 01:14:21PM -0400, Tony Nelson wrote:
> >> I use MySQL, but sort of intend to learn PostgreSQL.  I didn't know that
> >> PostgreSQL has no real support for BLOBs.
> > 
> >    I think it has - BYTEA data type.
> > 
> But the Python DB adapters appears to require some fairly hairy escaping
> of the data to make it usable with the cursor execute() method. IMHO you
> shouldn't have to escape data that is passed for insertion via a
> parameterized query.

can't you simply use dbmodule.Binary to do the job?

Sylvain Thénault                               LOGILAB, Paris (France)
Formations Python, Debian, Méth. Agiles: http://www.logilab.fr/formations
Développement logiciel sur mesure:       http://www.logilab.fr/services
CubicWeb, the semantic web framework:    http://www.cubicweb.org

More information about the Python-Dev mailing list