Re: Can I Save images in postgres?

From: Yaroslav Tykhiy <yar(at)barnet(dot)com(dot)au>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: 纪晓曦 <sheepjxx(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Can I Save images in postgres?
Date: 2009-09-09 01:38:17
Message-ID: D5967786-A2AC-47DD-825E-DAE59FC8986C@barnet.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-09-09 01:50:49 Re: where clauses and multiple tables
Previous Message Yaroslav Tykhiy 2009-09-09 01:32:10 Re: where clauses and multiple tables