Re: Doubt :- Image_Insert

From: Jerome Alet <alet(at)librelogiciel(dot)com>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: sreejith s <getsreejith(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Doubt :- Image_Insert
Date: 2004-11-22 14:09:24
Message-ID: 20041122140924.GA25819@mail.librelogiciel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

On Mon, Nov 22, 2004 at 08:54:20AM -0500, Rod Taylor wrote:
> On Mon, 2004-11-22 at 19:11 +0530, sreejith s wrote:
> > Hello friends I have a doubt,
> > Is it possible to insert images into a postgres db. What is its
> > datatype. Is its possible to insert jpeg images. or v have to store
> > the path into the db. Pls reply. its urgent.
>
> Use bytea for a datatype. PostgreSQL can comfortably handle 50MB's worth
> of data and uncomfortably handle 1GB if you have enough RAM per tuple.

You mean "handle 50MB's worth of data" per tuple or as a whole ?

Same question for 1GB.

this is not really clear...

bye

Jerome Alet

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2004-11-22 14:10:09 Re: Doubt :- Image_Insert
Previous Message Rod Taylor 2004-11-22 13:54:20 Re: Doubt :- Image_Insert