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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
