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/