| 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: | Whole Thread | Raw Message | 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
| 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 |