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 h8nv8c$cg5$1@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, 纪晓曦 <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.

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Problems with pg_dump for PG8.4 for WinXP (MinGW build)
Next
From: Jasen Betts
Date:
Subject: Re: Can I Save images in postgres?