Re: Can I Save images in postgres?

Поиск
Список
Период
Сортировка
От 纪晓曦
Тема Re: Can I Save images in postgres?
Дата
Msg-id 37a11ce00909082036s5cb072afg95bdd42e73905ef3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can I Save images in postgres?  (Yaroslav Tykhiy <yar@barnet.com.au>)
Список pgsql-general
Thank you very much. It seems it is better to save it on file system.

2009/9/9 Yaroslav Tykhiy <yar@barnet.com.au>
On 09/09/2009, at 10:43 AM, John R Pierce wrote:

纪晓曦 wrote:
Can I save images in the postgres? How to define? Does the format matters? Can I save JPG/PNG?How?

you can save images as BYTEA data, and the format is totally up to your application, as postgres just treats it as a block of bytes.    however, I generally find it easier to store my images on a file system, and just put the file path in the database.

By the way, here's a relatively recent discussion of this issue:

http://archives.postgresql.org/pgsql-general/2009-06/msg00599.php

Yar

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Using symbolic links with tablespaces
Следующее
От: miller_2555
Дата:
Сообщение: Re: Using symbolic links with tablespaces