Image Insert Postgresql DB
| От | sreejith s |
|---|---|
| Тема | Image Insert Postgresql DB |
| Дата | |
| Msg-id | 5d14ecf904112220214ec08992@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Image Insert Postgresql DB
Re: Image Insert Postgresql DB |
| Список | 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
В списке pgsql-sql по дате отправления: