I want to create a CSV with PostgreSQL 9.1 COPY that directly opens correctly with a double-click in crazy German Excel 2010. Using ";"-Delimiter is easy. The encoding is solved, but Excel only recognizes numbers correctly if they use the , as decimal seperator.
Thats what the CSV should look like;
Thats what the CSV looks like now:
Is there a way to do that with COPY?
What I tried:
SHOW lc_numeric; "de_DE.UTF-8"
is set but has no effect.
I found to_char(double precision, text) function. But my table has ~200 columns. Will I have to put to_char( column , 'FM9999999999999999D999999999999999999') for every numeric column? Is there any setting to make COPY change it automagically?
Thanks in advance, Steve