Re: [ADMIN] lo_import

2012-01-03 Thread Fabrízio de Royes Mello
Em 3 de janeiro de 2012 17:05, Maurício Cruz 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 su

[ADMIN] lo_import

2012-01-03 Thread Maurício Cruz
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

Re: [ADMIN] lo_import/lo_export in other table

2011-08-16 Thread Nelson Gonzaga
Greg, Very cool your idea, I'll use it in my app. And about lo_export, how can I get the file from this table?   Tks, Nelson De: Greg Spiegelberg Para: Nelson Gonzaga Cc: pgsql admin Enviadas: Terça-feira, 16 de Agosto de 2011 9:04 Assunto: Re: [ADMIN] lo_import/lo_export in other table

Re: [ADMIN] lo_import/lo_export in other table

2011-08-16 Thread Greg Spiegelberg
On Fri, Aug 12, 2011 at 12:31 PM, Nelson Gonzaga wrote: > Hi all, > How can I modify (or create other one) lo_import to save data in my table > (not in pg_largeobject). > Because I'm making an app that create a table with my fields and a bytea > field, but .net doesn't read that field like lo_exp

[ADMIN] lo_import/lo_export in other table

2011-08-12 Thread Nelson Gonzaga
Hi all, How can I modify (or create other one) lo_import to save data in my table (not in pg_largeobject). Because I'm making an app that create a table with my fields and a bytea field, but .net doesn't read that field like lo_export.   Any ideas?   tks in advance,

[ADMIN] lo_import

2006-01-18 Thread sandhya
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 existHINT:  No function matches the given name and argument types. You may need to add explicit type casts.