Re: Can I Save images in postgres?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: 纪晓曦 <sheepjxx(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can I Save images in postgres?
Date: 2009-09-09 00:43:53
Message-ID: 4AA6FA49.6010005@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message miller_2555 2009-09-09 01:23:53 Re: Using symbolic links with tablespaces
Previous Message Scott Frankel 2009-09-09 00:23:10 Re: where clauses and multiple tables