On Fri, 22 Jan 1999, Martin Wong wrote:
# it seems to work fine but it is an extra overhead when it creates a tmp
# file. How can this be cached? Or can it be directed directly to the web
# page instead of having to go through another step of createing a temp
# file.
Your application sh
Hi,
You can use the lo_open() - lo_read() - lo_write() - lo_seek() C like functions
that allow to read, write and more directly into your blobs and so display data
on the fly...
This is already in the documentation - PostgreSQL Programmer's Guide - Chapter
15. Large Objects.
Martin Wong wrote:
Dear all,
I have a pgsql database table packed with images and another one packed with
text files, all blobs. I have a script in perl which first extracts the
images/text via the lo_export into a temp directory on my server and then
it'll display the contents of the file on an HTML page passing H
