Merlin Moncure wrote: > On 1/10/07, Dimitri Fontaine <dim@xxxxxxxxxx> wrote: > > Hi, > > > > Le mercredi 10 janvier 2007 02:54, garrettmoore@xxxxxxxxx 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. > > If you are using pg 8.2+, I've had good luck with the following: > > 1. create pgsql schema by hand or using some method, so they match mysql > 2. mysqldump --compatible=postgresql [yadda] | grep ^INSERT | psql [yadda] Wow, mysqldump has a postgresql compatibility mode? Intersting. -- Bruce Momjian bruce@xxxxxxxxxx EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
