1
Guys, I need to copy a physical file from one directory to another, but for this I need to use Postgres.
I’m using LO’s functions to do this. I can perfectly copy the file when it has no accents, but when it has I get the following error when I run the function in pgAdmin:
"Not Connected to the server or the Connection to the server has been closed."
I have tried to run straight at the command prompt and the error is this one:
The copy script is here
DO $$
declare
l_oid oid;
BEGIN
select lo_import('c:\_anexos\anexo_pessoas_juridicas\128__Curriculos.doc') into l_oid;
perform lo_export(l_oid, 'c:\_anexos\128__Curriculos.doc');
END $$
But the same problem is in the part of lo_import