Description of lo_import and lo_export

From: "Ing(dot) Roberto Andrade" <randrade(at)campus(dot)iztacala(dot)unam(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: Description of lo_import and lo_export
Date: 1999-03-04 19:18:47
Message-ID: Pine.SOL.3.91.990304131756.21741F-100000@campus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Remigiusz Sokolowski 1999-03-05 11:53:17 rules
Previous Message Pavel PaJaSoft Janousek 1999-03-04 18:06:20 Minimal rights