On 2009-09-09, John R Pierce <pierce(at)hogranch(dot)com> 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.
storing images in the database is useful when providing filesystem
access to a shared location is inconvenient, and also helps with data
integrity.