pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

lo_import
3+ messages / 3 participants
[nested] [flat]

* lo_import
@ 2012-01-03 12:32 Maurício Cruz <cruz@sygecom.com.br>
  2012-01-03 18:34 ` Re: lo_import Tim Landscheidt <tim@tim-landscheidt.de>
  2012-01-03 19:17 ` Re: lo_import Jasen Betts <jasen@xnet.co.nz>
  0 siblings, 2 replies; 3+ messages in thread

From: Maurício Cruz @ 2012-01-03 12:32 UTC (permalink / raw)
  To: pgsql-sql

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

Thanks every one.
Cruz




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: lo_import
  2012-01-03 12:32 lo_import Maurício Cruz <cruz@sygecom.com.br>
@ 2012-01-03 18:34 ` Tim Landscheidt <tim@tim-landscheidt.de>
  1 sibling, 0 replies; 3+ messages in thread

From: Tim Landscheidt @ 2012-01-03 18:34 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: lo_import
  2012-01-03 12:32 lo_import Maurício Cruz <cruz@sygecom.com.br>
@ 2012-01-03 19:17 ` Jasen Betts <jasen@xnet.co.nz>
  1 sibling, 0 replies; 3+ messages in thread

From: Jasen Betts @ 2012-01-03 19:17 UTC (permalink / raw)
  To: pgsql-sql

On 2012-01-03, Maurício Cruz <cruz@sygecom.com.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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2012-01-03 19:17 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-01-03 12:32 lo_import Maurício Cruz <cruz@sygecom.com.br>
2012-01-03 18:34 ` Tim Landscheidt <tim@tim-landscheidt.de>
2012-01-03 19:17 ` Jasen Betts <jasen@xnet.co.nz>

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