Received: from campus.campus.iztacala.unam.mx (campus.iztacala.unam.mx [132.248.79.80]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA89017 for ; Thu, 4 Mar 1999 14:15:42 -0500 (EST) (envelope-from randrade@campus.iztacala.unam.mx) Received: (from randrade@localhost) by campus.campus.iztacala.unam.mx (8.8.8+Sun/8.8.8) id NAA22300; Thu, 4 Mar 1999 13:18:48 -0600 (CST) Date: Thu, 4 Mar 1999 13:18:47 -0600 (CST) From: "Ing. Roberto Andrade" X-Sender: randrade@campus To: pgsql-sql@postgresql.org Subject: Description of lo_import and lo_export Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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