Re: Trying to load MySQL data

Merlin Moncure wrote:
> On 1/10/07, Dimitri Fontaine <dim(at)dalibo(dot)com> wrote:
> > 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.
>
> 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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

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