i think i cross posted here from the psycopg ml something on the argument a week ago... looking at the mailing lists... ok. found. you'll find a little example in how to save a jpg image to postgresql here: http://lists.initd.org/pipermail/psycopg/2001-June/000201.html if you need more help, don't esitate to write again, federico On 29 Jun 2001 09:07:48 -0700, Vid B wrote:
I am storing BLOBs in PSQL using lo_import, and exporting them to the file system using lo_export. But I cannot figure out how to display them directly from the database to the web page. Files will be of different format: jpg, gif, pdf, wpd, doc, ...
postgresql 7.1 does not have any limit on row size. just call a python method that squeezes the data into a text column and retrieve it.
hope this helps, federico
-- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org The number of the beast: vi vi vi. -- Delexa Jones
Hi Federico,
I am glad to hear that python solution for publishing the files (especially images) from database to web pages exists. I found ASP, PHP, Perl solutions, but it did not help me. Can you give me more details how python solution looks like or if you have working example?
Thanks
Vid
__________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
-- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org Try the Joy of TeX [http://www.tug.org] -- brought to you by One Line Spam