Re: Data type for storing images?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Data type for storing images?
Дата
Msg-id 23574.984361701@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Data type for storing images?  (<drevil@sidereal.kz>)
Ответы Re: Data type for storing images?
Re: Data type for storing images?
Список pgsql-general
<drevil@sidereal.kz> writes:
> I would like to store some images in my Postgres database.  These will
> all be thumbnails, limited to 4k or 5k.  I know that PG has an 8k row
> limit, but this should be fine, because there's not much else in the
> row.  Which data type could I use to store them, and is there a
> performance cost for having rows that are this big?  The system will
> be using PG7.1, btw.

bytea is probably your best bet.  The 8k limit is toast in 7.1, btw.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Anyone can create tables!
Следующее
От: Dan McGrath
Дата:
Сообщение: Re: Re: Anyone can create tables!