Re: Import German Number Format

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Tim Semmelhaack" <semmelhaack(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Import German Number Format
Date: 2008-10-02 13:51:54
Message-ID: 36e682920810020651n60c42c44jfba1c73d7732c0f6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 2, 2008 at 9:35 AM, Tim Semmelhaack <semmelhaack(at)gmail(dot)com> wrote:
> The numbers are formatted with decimal comma ',' (as usual in Germany)
> instead of the decimal point '.'
>
> When I try to import this data Postgres crashes, so I think I have to
> change a parameter with SET? Does anybody know which parameter I have
> to change?

Independent of locale-related settings, I don't believe PG will accept
a comma as input in this case.

--
Jonah H. Harris, Senior DBA
myYearbook.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-10-02 14:15:10 Re: Transactions within a function body
Previous Message A. Kretschmer 2008-10-02 13:51:00 Re: Import German Number Format