pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlo_import
3+ messages / 3 participants
[nested] [flat]
* lo_import
@ 2006-01-19 07:06 sandhya <sandhyar@amiindia.co.in>
0 siblings, 0 replies; 3+ messages in thread
From: sandhya @ 2006-01-19 07:06 UTC (permalink / raw)
To: pgsql-admin
When i am using lo_import to load files into the database i am getting the following error.....
Please help me what i need to do
ERROR: function lo_import ("unknown") does not exist
HINT: No function matches the given name and argument types. You may need to ad
d explicit type casts.
^ permalink raw reply [nested|flat] 3+ messages in thread
* lo_import
@ 2012-01-03 19:05 Maurício Cruz <cruz@sygecom.com.br>
0 siblings, 1 reply; 3+ messages in thread
From: Maurício Cruz @ 2012-01-03 19:05 UTC (permalink / raw)
To: pgsql-admin
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-04 00:01 Fabrízio de Royes Mello <fabriziomello@gmail.com>
parent: Maurício Cruz <cruz@sygecom.com.br>
0 siblings, 0 replies; 3+ messages in thread
From: Fabrízio de Royes Mello @ 2012-01-04 00:01 UTC (permalink / raw)
To: Maurício Cruz <cruz@sygecom.com.br>; +Cc: pgsql-admin
Em 3 de janeiro de 2012 17:05, Maurício Cruz <cruz@sygecom.com.br> escreveu:
> Hi all,
>
>
Hi Mauricio,
> 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"
>
>
It's the default behavior.
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 ?
>
>
The lo_import/lo_export functions read/write files in the same file system
where postgres server is running [1]...
If you need send some file from your client to your database server you
must verify the implementation of libpq API in your programming language to
use another functions (lo_creat, lo_open, lo_write, lo_read) to create LOs
from your client side of connection into your server [2].
Another way is using "psql" client program [3] to import/export large
objects.
[1] http://www.postgresql.org/docs/9.1/static/lo-funcs.html
[2] http://www.postgresql.org/docs/9.1/static/lo-examplesect.html
[3] http://www.postgresql.org/docs/9.1/static/app-psql.html
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-01-04 00:01 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-19 07:06 lo_import sandhya <sandhyar@amiindia.co.in>
2012-01-03 19:05 lo_import Maurício Cruz <cruz@sygecom.com.br>
2012-01-04 00:01 ` Fabrízio de Royes Mello <fabriziomello@gmail.com>
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