From: sreejith s <getsreejith@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Image Insert Postgresql DB
Date: Tue, 23 Nov 2004 09:51:12 +0530
Message-ID: <5d14ecf904112220214ec08992@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: getsreejith@gmail.com
Subject: Re: Image Insert Postgresql DB
In-Reply-To: <5d14ecf904112220214ec08992@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox