Merlin Moncure wrote: > On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote: > > 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. > > 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 [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
