[postgis-users] Changing regional setting for a numeric field in a single database

[Robert Buckley]

Hi,

on trying to import data from csv I am now having a problem with regional settings. 

At the moment it looks like this;

db=#show client_encoding;

UTF8


db=#show lc_numeric;

de_DE.utf8


The problem is that I have getting this error;

ERROR:  invalid input syntax for type numeric: "2.000,000"


I have defined this field as...

 numeric(11,4)

and thus the problem is that the decimal and thousand separators are mixed up.

Would anyone know how I can set this properly to this one database?


Thanks for any help,

Rob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120628/295b14b1/attachment.html>