Re: Import German Decimal Numbers

From: Dimitri Fontaine <dim(at)hi-media(dot)com>
To: Tino Wildenhain <tino(at)wildenhain(dot)de>
Cc: Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de>, pgsql-general(at)postgresql(dot)org, Jan Christian Dittmer <jcdittmer(at)web(dot)de>
Subject: Re: Import German Decimal Numbers
Date: 2008-05-08 11:59:14
Message-ID: 0729262F-6995-4FBF-B784-DD5F6569D2F0@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Le 7 mai 08 à 15:57, Tino Wildenhain a écrit :
> There is also http://pgfoundry.org/projects/pgloader/
> and if not already implemented it should be fairly
> easy to implement a data filter within this one.

pgloader indeed support user reformating modules, and comes with a
mysql to pgsql timestamp reformater. Adding a python .py module
containing one function to handle the change should be easy, the
documentation has needed details if you look for "reformat_path" and
"reformat" options.
http://pgloader.projects.postgresql.org/

Plus, pgloader supports setting the DateStyle before running copy,
maybe this will be enough in your case? (didn't read all the thread).

If you need more help than current documentation to setup your
reformating module, please just ask!

Regards,
--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2008-05-08 12:03:39 Re: Custom Base Type in C
Previous Message Fernando Schapachnik 2008-05-08 11:52:07 Is this a bug? (changing sequences in default value)