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

On Tue, Feb 5, 2013 at 3:47 PM, Thierry Hauchard <gesteam_l4d(at)gesteam(dot)fr>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