Re: Trying to load MySQL data

Hi,

Le mercredi 10 janvier 2007 02:54, garrettmoore(at)gmail(dot)com a écrit :
> I am working on a project where we are converting from MySQL to
> Postgres. I figured the easiest way would be to export the MySQL data
> as CSV.

You could also give pgloader a try.
It uses COPY but allows you to load good data even in the presence of errors,
and have a reject file containing erroneous data lines, to replay insertion
later.
It even allows you to reorder data for matching your columns definition, but
as of now suffer from a psycopg2 limitation : you have to provide all table
columns into your data file.

http://pgfoundry.org/projects/pgloader/
http://debian.dalibo.org/unstable/
http://debian.dalibo.org/unstable/pgloader_2.0.2.tar.gz

Hope this helps,
--
Dimitri Fontaine
http://www.dalibo.com/