Can I Save images in postgres?

纪晓曦 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.

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

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 2009-09-09, 纪晓曦 <sheepjxx@gmail.com> wrote:

--001636834258521c91047319fd34
Content-Type: text/plain; charset=ISO-8859-1

Can I save images in the postgres?

yes.

How to define?

a bytea column it probably a good start

Does the format matters?

not to postgres.

base64 or hex encoding and storing in a text filed also works.

On 2009-09-09, John R Pierce <pierce@hogranch.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.