Re: locale question - Mailing list pgsql-admin

From Tom Lane
Subject Re: locale question
Date
Msg-id 7740.1007133711@sss.pgh.pa.us
Whole thread Raw
In response to locale question  (Oliver Vecernik <vecernik@aon.at>)
List pgsql-admin
Oliver Vecernik <vecernik@aon.at> writes:
> ERROR:  copy: line 1, Bad numeric input format '1018,11'

> It seems the price with , is not recognized by psql, although LANG is set.

IIRC, the only numerical datatype we have that allows locale-specific
formatting is MONEY, which is deprecated for lack of sufficient range.

I'm afraid you'll have to do some sed-hacking on your datafile.  Sorry.

            regards, tom lane

pgsql-admin by date:

Previous
From: Brian McCane
Date:
Subject: Re: table test
Next
From: Mikhail Terekhov
Date:
Subject: Re: Visio