On Tue, Feb 5, 2013 at 3:47 PM, Thierry Hauchard <gesteam_l4d@gesteam.fr>wr=
ote:
> 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=E9noms/datas.txt' is so impossible.
>
> Is there a turnover ?
>
> PG 8.4, Windows XP
Hmm...seems accent character not recognized by COPY command.
postgres=3D# copy users from 'c:/test/*=E5*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-speci=
al-characters-from-filenames-windows
Some other's might have better workarounds.
--Raghav