Re: Trying to load MySQL data

On 1/11/07, Bruce Momjian <bruce@momjian.us> wrote:
> 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.

It does (had it for years), but it doesn't do very much...fixes the
quotes and a couple of other  things.  In particular I know of no easy
ways to convert the table schemas without use of external tools.

merlin