Questions about the use of largeobject functions from inside SQL

From: Marco Bizzarri <m(dot)bizzarri(at)icube(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions about the use of largeobject functions from inside SQL
Date: 2005-03-16 09:41:30
Message-ID: 4237FF4A.9070502@icube.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

We have a setup with Zope and a remote Postgresql server. We're storing
blobs in largeobject files.

What we need to do is to be able to do the transfer of blobs between
Zope and postgres. I thought it was possible to use lo_* functions, by
creating a largeobject, and then sending the data using an lo_write, but
I'm unable to figure how to do this in SQL.

Any suggestions?

Note:

1) NFS in order to share disk space between the two servers is not an
option (in that case, I would be able to use lo_import/lo_export);

2) We're using ZPsycopgDA on the client side

3) I'm not on the list, so please CC to me directly

Regards
Marco

Browse pgsql-general by date

  From Date Subject
Next Message Bhabani Sankar Jena 2005-03-16 10:07:08 Need Help on ODBC Driver testing........
Previous Message Fred Blaise 2005-03-16 08:19:55 Re: pg/plsql question