From: | Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Optional Exporting or copying result with (,) as decimal mark |
Date: | 2011-01-06 23:43:05 |
Message-ID: | AANLkTi=FTDDQtCvjWGWbSDoSiwowvkKRmW2h76CH12L1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi,
in pgsql it's not possible to define, that numeric values are returned in
localized numeric format. In our case (Austria) we use comma as decimal mark
and not period.
When opening a pgadmin-exported CSV-File, we have troubles in Excel, because
it doesn't recognize numeric values properly. We would have to change the
locale settings in excel so that this works properly.
This patch enables an option in the query tool tab, where you can decide if
you like to use comma as decimal mark. It only applies on numeric values.
It also works, if you copy and paste from the result grid into excel.
I've done this work to make my people's life at work easier. If it's not
suitable for a release, please ignore it. In this case I'm going to build
"our own" version of pgadmin on each release.
Regards,
Jasmin
Attachment | Content-Type | Size |
---|---|---|
0001-Optional-replacing-.-to-when-exporting-or-copying-sq.patch | application/octet-stream | 6.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jasmin Dizdarevic | 2011-01-07 02:00:38 | [SOLVED] Fwd: Debug works, Release not |
Previous Message | Jasmin Dizdarevic | 2011-01-06 22:38:26 | Re: Support for unlogged tables |