Re: Can I Save images in postgres?

On 2009-09-09, 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.

storing images in the database is useful when providing filesystem
access to a shared location is inconvenient, and also helps with data
integrity.