Error importing file with accents - Postgres

Asked

Viewed 207 times

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:

inserir a descrição da imagem aqui

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

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.