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
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
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
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
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,
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.