Re: Load Image File From PostgreSQL DB - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Load Image File From PostgreSQL DB
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202EA7575@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: Load Image File From PostgreSQL DB  ("dbalinglung" <alamsurya@centrin.net.id>)
Responses Re: Load Image File From PostgreSQL DB  (Julius Tuskenis <julius.tuskenis@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: justin
Date:
Subject: Re: [PGSQL 8.3.5] Use of a partial indexes
Next
From: Julius Tuskenis
Date:
Subject: Re: Load Image File From PostgreSQL DB