Re: Optional Exporting or copying result with (,) as decimal mark - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Optional Exporting or copying result with (,) as decimal mark
Date
Msg-id AANLkTinK=f=uikJEsW6d4Ht4ud9+21bXvK=e9U6NEmtT@mail.gmail.com
Whole thread Raw
In response to Re: Optional Exporting or copying result with (,) as decimal mark  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
List pgadmin-hackers
On Fri, Jan 7, 2011 at 11:44 AM, Jasmin Dizdarevic
<jasmin.dizdarevic@gmail.com> wrote:
> This is absolutely the correct way, but I think pgAdmin is the wrong
> location to handle this. In my opinion the database should handle locales.
> The COPY command for example also doesn't support other decimal marks. AND
> it's not always wanted, that the input is locale aware. There has to be an
> optional parameter or a session based setting. But that's a topic for an
> other mailing list ;)
> I know my patch is just a workaround, but it saves us a lot of time in this
> particular process.

locale is always handled in the client - especially as data may be
transferred to/from the server in binary formats where locale is
irrelevant.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-hackers by date:

Previous
From: Jasmin Dizdarevic
Date:
Subject: Re: Optional Exporting or copying result with (,) as decimal mark
Next
From: Dave Page
Date:
Subject: Re: Debug works, Release not