[Zope] Storing Images in PostgreSQL

[nico@beehive.de]

hi andreas,

thanks!
I do not use popy DA but Psycopg DA that supports commands for handling
postgres large objects. I uploaded an image from the file system into my
sql table using lo_import in a ZSQL mehtod. What I don't know is, how to
store an image using a simple input form similiar to upload an image into
the ZODB. Furthermore, I did not found any documentation on how to get
the image from the database table to display it in DTML. Once I get it
running, I should write a how-to. :-)

nico 


On Tue, 23 Apr 2002, Andreas Heckel wrote:

> nico@beehive.de wrote:
> > 
> > Hello,
> > 
> > I am trying to store images in a PostgreSQL 7.2 database using the Psycopg
> > database adapter, running Zope 2.5.0 on redhat linux.
> > I found a tip at
> > http://lists.initd.org/pipermail/psycopg/2001-June/000200.html and tried
> > it out. Unfortunately I get an error like "Can't parse object
> > 'Gif123/'..."
> > 
> > Is there any documentation on how to store images in a PostgreSQL database
> > from Zope ?
> 
> You need a postgres DA that supports commands for handling postgres
> Large Objects (loimport,getlo,unlink ...)
> 
> As far as I know popy tries to store binary data into a bytea field ...
> don't know if it works.  
> 
> -- 
> _______________________________________________________________________
> Andreas Heckel                                  andreas@easyleading.org
>