Mail-Followup-To: pgsql-sql@postgresql.org
To: pgsql-sql@postgresql.org
From: Tim Landscheidt <tim@tim-landscheidt.de>
Subject: Re: lo_import
Date: Tue, 03 Jan 2012 18:34:31 +0000
Organization: <URI:http://www.tim-landscheidt.de/>
Lines: 17
Message-ID: <m3k458ab48.fsf@passepartout.tim-landscheidt.de>
References: <4EF9AFC2.3090204@sygecom.com.br>
 <4F02F544.9070506@sygecom.com.br>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Mail-Copies-To: never
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
Cancel-Lock: sha1:fQ48FuiEU8Efc8RORjGGSlcbtf4=

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