Re: [GENERAL] DISPLAYING BLOBS/images/text

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 HTML headers
> inbetween.
>
> 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.
>
> What do you all say?
>
> Thanks