Re: Load Image File From PostgreSQL DB

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Load Image File From PostgreSQL DB
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C202EA7575@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: Load Image File From PostgreSQL DB  ("dbalinglung" <alamsurya@centrin.net.id>)
Ответы Re: Load Image File From PostgreSQL DB
Список 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 по дате отправления:

Предыдущее
От: justin
Дата:
Сообщение: Re: [PGSQL 8.3.5] Use of a partial indexes
Следующее
От: Julius Tuskenis
Дата:
Сообщение: Re: Load Image File From PostgreSQL DB