X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A0C6A3A5264 for ; Mon, 22 Nov 2004 14:09:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34446-04 for ; Mon, 22 Nov 2004 14:09:33 +0000 (GMT) Received: from nordine.ateur (main.librelogiciel.com [62.212.108.58]) by svr1.postgresql.org (Postfix) with ESMTP id C39BC3A526C for ; Mon, 22 Nov 2004 14:09:35 +0000 (GMT) Received: from jerome by nordine.ateur with local (Exim 3.36 #1 (Debian)) id 1CWEse-0006kk-00; Mon, 22 Nov 2004 15:09:24 +0100 Date: Mon, 22 Nov 2004 15:09:24 +0100 To: Rod Taylor Cc: sreejith s , pgsql-sql@postgresql.org Subject: Re: Doubt :- Image_Insert Message-ID: <20041122140924.GA25819@mail.librelogiciel.com> References: <5d14ecf90411220541659b2d30@mail.gmail.com> <1101131660.4697.362.camel@home> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1101131660.4697.362.camel@home> User-Agent: Mutt/1.5.6+20040907i From: Jerome Alet X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/228 X-Sequence-Number: 19547 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