On 2009-09-09, John R Pierce <pierce@xxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
