Re: COPY FROM on Windows and accentuated characters in the file path

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

On Tue, Feb 5, 2013 at 3:47 PM, Thierry Hauchard <gesteam_l4d@xxxxxxxxxx> wrote:

Hi,

Using COPY FROM doesn't work if the path of the file has accentuated characters : command doesn't find the file.
COPY FROM 'C:/import/prénoms/datas.txt' is so impossible.

Is there a turnover ?

PG 8.4, Windows XP

Hmm...seems accent character not recognized by COPY command. 

postgres=# copy users from 'c:/test/åtest.txt';

ERROR:  could not open file "c:/test/+test.txt" for reading: No such file or directory

I guess you should take help of batch script to remove ACCENT characters and your COPY should be good to go.

Below link when I googled:

http://stackoverflow.com/questions/261515/batch-file-script-to-remove-special-characters-from-filenames-windows

Some other's might have better workarounds.

--Raghav