Storing images in PG?

Поиск
Список
Период
Сортировка
От Dr. Evil
Тема Storing images in PG?
Дата
Msg-id 20010816060200.2212.qmail@sidereal.kz
обсуждение исходный текст
Ответы Re: Storing images in PG?  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-general

I am creating a DB which is going to have to store a lot of small
images.  Nothing will be over 10k.  This is with PG7.2.  I have a few
questions: Should I use blob or bytea (neither seem to be well
documented), and how do I access that binary information?  For
instance, if I have this table in PG:

CREATE TABLE imagetable (
       ....
       image BYTEA,
       ....
);

and then I do this in PHP:

$result = pg_exec($db, "SELECT image FROM imagetable WHERE ...");
$ary = pg_fetch_array($result, 0);
$imagedata = $ary["image"];

Will all of the above work?

If I can handle images in the DB, this is going to be the coolest
wireless app.

Thanks

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: select distinct and order by
Следующее
От: Karel Zak
Дата:
Сообщение: Re: Storing images in PG?