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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users