COPY FROM on Windows and accentuated characters in the file path

On Tue, Feb 5, 2013 at 11:17:55AM +0100, Thierry Hauchard 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

This must be a mismatch between your operating system encoding and your
database encoding.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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