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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to