On Tue, Feb 5, 2013 at 3:47 PM, Thierry Hauchard <gesteam_...@gesteam.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
