Re: lo_import - Mailing list pgsql-sql

From Tim Landscheidt
Subject Re: lo_import
Date
Msg-id m3k458ab48.fsf@passepartout.tim-landscheidt.de
Whole thread Raw
In response to Call a external app on postgreSQL start-up (windows)  (Maurício Cruz <cruz@sygecom.com.br>)
List pgsql-sql
Maurício Cruz <cruz@sygecom.com.br> wrote:

> 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...
> I will have to upload the file into the server and then use
> import  ?   is there any other way ?

Create a large object and then write to it?  What driver are
you using?

Tim



pgsql-sql by date:

Previous
From: Maurício Cruz
Date:
Subject: lo_import
Next
From: Jasen Betts
Date:
Subject: Re: lo_import