Re: Display large object from database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg" <greg(at)officium(dot)co(dot)za>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Display large object from database
Date: 2006-06-05 14:55:26
Message-ID: 20202.1149519326@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Greg" <greg(at)officium(dot)co(dot)za> writes:
> I am battling to open the image for reading into a stream.

From what? The lo_xxx functions are intended to be used from C, not
from SQL.

You might be better off using a bytea column, which is a far simpler
construct than a large object. It won't give you streamwise access,
just fetch or store the whole value at once, but that might be all you
need.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message greg 2006-06-05 17:11:33 Re: Display large object from database
Previous Message Greg 2006-06-05 12:28:49 Display large object from database