Subject: Re: Doubt :- Image_Insert
From: Rod Taylor <pg@rbt.ca>
To: Jerome Alet <alet@librelogiciel.com>
Cc: sreejith s <getsreejith@gmail.com>, pgsql-sql@postgresql.org
In-Reply-To: <20041122140924.GA25819@mail.librelogiciel.com>
References: <5d14ecf90411220541659b2d30@mail.gmail.com>
	<1101131660.4697.362.camel@home>
	<20041122140924.GA25819@mail.librelogiciel.com>
Content-Type: text/plain
Date: Mon, 22 Nov 2004 09:10:09 -0500
Message-Id: <1101132609.4697.364.camel@home>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Mon, 2004-11-22 at 15:09 +0100, Jerome Alet wrote:
> 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 ?

Per tuple. There is no practical limit to how much it can handle as a
whole.

--