Re: [SQL] Large Objects - Mailing list pgsql-sql

From Chris Bitmead
Subject Re: [SQL] Large Objects
Date
Msg-id 37814B35.CEA20AD0@ozemail.com.au
Whole thread Raw
In response to Large Objects  ("Eid, Bilal" <Bilal_Eid@NAI.com>)
List pgsql-sql
If I understand your question correctly, the answer is that lo_creat
returns an oid. You need to have a column in a regular table of type oid
and store this oid in there. When you query the table later you can get
the oid and pass it to lo_open.

"Eid, Bilal" wrote:

> Again, and in short, I need to attach an object to a table using the iODBC
> application and using buffer instead of file as input/output.
> Is there any way to do that? I need your help and may be some example to
> follow.
> Please, Help me I'm running out of time.


pgsql-sql by date:

Previous
From: "Eid, Bilal"
Date:
Subject: Large Objects
Next
From: Olivier Ertz
Date:
Subject: PB creating view : DefineQueryRewrite: rule plan string too big