Received: from mail.ldssingles.com (mail.ldssingles.org [63.226.117.101]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4OJbrA03596 for ; Thu, 24 May 2001 15:37:56 -0400 (EDT) (envelope-from mark@zserve.com) Received: from mark.ldssingles.com (mark.ldssingles.com [192.168.1.31]) by mail.ldssingles.com (8.11.2/8.11.2) with ESMTP id f4OJbkW04414 for ; Thu, 24 May 2001 13:37:46 -0600 Message-Id: <200105241937.f4OJbkW04414@mail.ldssingles.com> Subject: photos and OID's From: Mark To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution (0.9 - Preview Release) Date: 24 May 2001 12:45:53 -0600 Mime-Version: 1.0 X-Archive-Number: 200105/263 X-Sequence-Number: 3091 Hi all, Thanks for the great product. We store photos in the db and serve them up from web servers. We're using java servlets on separate web server boxes that are load balanced. NFS is not an option for us (unless nothing else is available). This works with byte streams using SQL Server from MS. But, we don't want to use SQL Server any more, we want to use PostgreSQL. We need to get the photo data from the db without any file system access. In other words, we need the bytes, not the OID. So I read docs and found lo_import/lo_export. But that would only work for us over NFS and would cause major complications. lo_export won't cut it for us unless we make some major changes. Can I use the standard JDBC Blob type to retrieve the photos? What other options do I have? Thanks, Mark