Error importing file with accents - Postgres

1

Well, I need to copy a physical file from one directory to another, but for that I need to use Postgres.

I'm using the LO functions to do this. I can perfectly copy the file when it has no accents, but when I have it 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 directly at the command prompt and the error is this here:

The copy script here

DO $$
declare
    l_oid oid;

BEGIN
    select lo_import('c:\_anexos\anexo_pessoas_juridicas8__Curriculos.doc') into l_oid;
    perform lo_export(l_oid, 'c:\_anexos8__Curriculos.doc');
END $$

But the same problem is in the part of lo_import

    
asked by anonymous 18.01.2017 / 13:09

0 answers