Re: Can I Save images in postgres?

Thank you very much. It seems it is better to save it on file system.

2009/9/9 Yaroslav Tykhiy <yar(at)barnet(dot)com(dot)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