Skip site navigation (1) Skip section navigation (2)

Re: lo_import

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: lo_import
Date: 2012-01-03 18:34:31
Message-ID: m3k458ab48.fsf@passepartout.tim-landscheidt.de (view raw or flat)
Thread:
Lists: pgsql-sql
Maurício Cruz <cruz(at)sygecom(dot)com(dot)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


In response to

  • lo_import at 2012-01-03 12:32:04 from Maurício Cruz

pgsql-sql by date

Next:From: Jasen BettsDate: 2012-01-03 19:17:33
Subject: Re: lo_import
Previous:From: Maurício CruzDate: 2012-01-03 12:32:04
Subject: lo_import

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group