Image Insert Postgresql DB

From: sreejith s <getsreejith(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Image Insert Postgresql DB
Date: 2004-11-23 04:21:12
Message-ID: 5d14ecf904112220214ec08992@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Vishal Kashyap @ [SaiHertz] 2004-11-23 04:37:22 Re: Image Insert Postgresql DB
Previous Message Pierre-Frédéric Caillaud 2004-11-22 23:19:17 Re: Recursive SETOF function