pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tim Landscheidt <tim@tim-landscheidt.de>
To: pgsql-sql@postgresql.org
Subject: Re: lo_import
Date: Tue, 03 Jan 2012 18:34:31 +0000
Message-ID: <m3k458ab48.fsf@passepartout.tim-landscheidt.de> (raw)
References: <4EF9AFC2.3090204@sygecom.com.br>
	<4F02F544.9070506@sygecom.com.br>

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




view thread (3+ messages)  latest in thread

Message-ID: <m3k458ab48.fsf@passepartout.tim-landscheidt.de>
Permalink:  ../m3k458ab48.fsf@passepartout.tim-landscheidt.de/
Also on:    postgresql.org/message-id/m3k458ab48.fsf@passepartout.tim-landscheidt.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tim@tim-landscheidt.de
  Subject: Re: lo_import
  In-Reply-To: <m3k458ab48.fsf@passepartout.tim-landscheidt.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox