On Thursday 2. October 2008, Tim Semmelhaack wrote:
>Hello,
>
>I have to import a huge number of data sets of data sets with "Copy
> from".
>
>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?
s/(\d{2}),(\d{2}),(\d{4})/$1.$2.$3/g
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/