Hi, Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] 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/
pgpJ9vvaKQZW1.pgp
Description: PGP signature
