Em 3 de janeiro de 2012 17:05, Maurício Cruz <cruz(at)sygecom(dot)com(dot)br> escreveu:
> Hi all,
> I'm trying to use lo_import to import a file into my database, if I
> execute from postgres runing in my local machine
> it works perfectly, but if I do it in the postgres runing in the server,
> it says "No such file or directory"
It's the default behavior.
I Guess postgres only see file on the machine it is runing and not through
> the network...
> I will have to upload the file into the server and then use import ? is
> there any other way ?
The lo_import/lo_export functions read/write files in the same file system
where postgres server is running ...
If you need send some file from your client to your database server you
must verify the implementation of libpq API in your programming language to
use another functions (lo_creat, lo_open, lo_write, lo_read) to create LOs
from your client side of connection into your server .
Another way is using "psql" client program  to import/export large
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
In response to
- lo_import at 2012-01-03 19:05:45 from Maurício Cruz
pgsql-admin by date
|Next:||From: Jeff Rule||Date: 2012-01-04 00:19:46|
|Subject: Re: unix domain sockets on Windows.|
|Previous:||From: Tripura||Date: 2012-01-03 21:52:15|
|Subject: Drop Schema from Postgres|