Re: Doubt :- Image_Insert - Mailing list pgsql-sql

From Jerome Alet
Subject Re: Doubt :- Image_Insert
Date
Msg-id 20041122140924.GA25819@mail.librelogiciel.com
Whole thread Raw
In response to Re: Doubt :- Image_Insert  (Rod Taylor <pg@rbt.ca>)
Responses Re: Doubt :- Image_Insert  (Rod Taylor <pg@rbt.ca>)
List 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


pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Doubt :- Image_Insert
Next
From: Rod Taylor
Date:
Subject: Re: Doubt :- Image_Insert