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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
