Re: Trying to load MySQL data

Merlin Moncure wrote:
> On 1/10/07, Dimitri Fontaine <dim@dalibo.com> wrote:
> > Hi,
> >
> > Le mercredi 10 janvier 2007 02:54, garrettmoore@gmail.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.
>
> 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@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +