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 31B453A2010 for ; Mon, 22 Nov 2004 13:56: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 28248-08 for ; Mon, 22 Nov 2004 13:56:38 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 61EDB3A5260 for ; Mon, 22 Nov 2004 13:56:40 +0000 (GMT) Received: from dyn-70-236.tor.dsl.tht.net (dyn-70-236.tor.dsl.tht.net [134.22.70.236]) by tht.net (Postfix) with ESMTP id 7398E76AC8; Mon, 22 Nov 2004 08:56:41 -0500 (EST) Subject: Re: Doubt :- Image_Insert From: Rod Taylor To: sreejith s Cc: pgsql-sql@postgresql.org In-Reply-To: <5d14ecf90411220541659b2d30@mail.gmail.com> References: <5d14ecf90411220541659b2d30@mail.gmail.com> Content-Type: text/plain Date: Mon, 22 Nov 2004 08:54:20 -0500 Message-Id: <1101131660.4697.362.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit 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/227 X-Sequence-Number: 19546 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 will need to properly escape the data to do the insertion, but the documentation (for DBI, PHP, Java, and PostgreSQL for the others) all clearly explain the steps to be taken. --