Hello, Albe
In the article you provided it is said that "The return value is the OID
that was assigned to the new large object..." (function Oid
lo_creat(PGconn *conn, int mode);). That means that not the large object
is stored in OID field - its just the reference to it.
Any way I find it much easier to get a relatively small blob in a result
set and not directly using lo_read function, because in delphi zeos
components does work with libpq, so theres no need to bypass them?
Julius Tuskenis
Albe Laurenz rašė:
> dbalinglung wrote:
>
>>> I seriously doubt you could store an image in oid typed column, because
>>> "The oid type is currently implemented as an unsigned four-byte
>>> integer." (from postgresql 8.2 manual). I too use Zeos with no problems
>>> using bytea type.
>>>
>> Ok, I'll try your sugestion, many thanks bro.
>>
>
> Large Objects (http://www.postgresql.org/docs/current/static/largeobjects.html)
> use OID columns, and they work fine for storing binary data like images.
>
> But bytea will work just as fine.
>
> Yours,
> Laurenz Albe
>
>