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 B14E13A3BA1 for ; Tue, 23 Nov 2004 04:21:34 +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 95440-07 for ; Tue, 23 Nov 2004 04:21:26 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by svr1.postgresql.org (Postfix) with ESMTP id AD9213A3BEE for ; Tue, 23 Nov 2004 04:21:24 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 71so288154wra for ; Mon, 22 Nov 2004 20:21:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=brkSMhIUTH/jbpj/y8jTWPxiAC/rErZSD+paUNavE2JmPnllvddo8IuckFLxAP3/irUBtNxILqpY4MiNOtLuEXm8bbpBwfe09e60HL7L+v3kr7RuYzTwqDj9EnQSxW/hWGZUO4KrPd4Fp5IgMHZivit3kK6EYrvk56vSUzKTFxI= Received: by 10.54.31.5 with SMTP id e5mr169139wre; Mon, 22 Nov 2004 20:21:16 -0800 (PST) Received: by 10.54.18.57 with HTTP; Mon, 22 Nov 2004 20:21:12 -0800 (PST) Message-ID: <5d14ecf904112220214ec08992@mail.gmail.com> Date: Tue, 23 Nov 2004 09:51:12 +0530 From: sreejith s Reply-To: sreejith s To: pgsql-sql@postgresql.org Subject: Image Insert Postgresql DB Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII 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/239 X-Sequence-Number: 19558 Hello I have a doubt regarding Image insert into Postgres DB. Yesterday i posted a query regarding this. and this one is in continuation. I am working on Project with Linux Server and Windows Client environment. And v r developing windows based application. V have to scan images from scanner attched to the client machine and these images r to be inserted into postgres db. Data type for Image field in the DB is OID. copy of Image file actually resides in the client. V have to insert this image into the DB. Query to insert ---------------- INSERT INTO Imagetable VALUES (lo_import('C:\\image\\peach.jpg')); here the path specified is the image path at client. But its doesn't work. Since it is not possible set the querys path to a remote machine. How i can insert the image into the DB at linux machine where the image file resides in the client machine. pls reply Sreejith