Re: Can I Save images in postgres? - Mailing list pgsql-general

From Jasen Betts
Subject Re: Can I Save images in postgres?
Date
Msg-id h8nveg$cg5$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Can I Save images in postgres?  (纪晓曦 <sheepjxx@gmail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Can I Save images in postgres?
Next
From: Inigo Barandiaran
Date:
Subject: Re: Regarding initdb & pg_ctl