Re: lo_import

On 2012-01-03, Maurício Cruz <cruz(at)sygecom(dot)com(dot)br> wrote:
> 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"
>
> I Guess postgres only see file on the machine it is runing and not
> through the network...

It can only see the files the database server can see.

> I will have to upload the file into the server and then use import ?

that would work

> is there any other way ?

the "\lo_import" command in psql, which reads files as the current
user anp pushes them through the database connection.

the best way is probably to add the file import feature to your
appplication.

--
⚂⚃ 100% natural