Thread: Description of lo_import and lo_export

Description of lo_import and lo_export

From
"Ing. Roberto Andrade"
Date:
Hi:

I need to show some jpgs that I have on a table. I know that it can be done using:

SELECT lo_export(image.raster, "/tmp/myfile" from image
    WHERE name = 'somename';

but this way I just can do it ONE at a time.

I want to show (save to fs) all or some of the images using something like:

SELECT lo_export(image.raster, "something") from image;

But I can't imagine how to do it!

TIA,

Roberto Andrade Fonseca