Re: Moving from MySQL to PGSQL....some questions

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Michael Chaney <mdchaney(at)michaelchaney(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving from MySQL to PGSQL....some questions
Date: 2004-03-02 18:57:40
Message-ID: 200403021857.i22Ive019767@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Chaney wrote:
> One other note, for those converting a database from MySQL to
> PostgreSQL, I have a table creation conversion script here:
>
> http://www.michaelchaney.com/downloads/m2p.pl
>
> I know that two come with PostgreSQL in the contrib directory, but I
> wrote this because those two didn't do what I needed. With this, you
> should be able to take the MySQL table creation scripts (as created by
> mysqldump --tab=x) and directly build the tables and load the data into
> a PostgreSQL db with little effort.

Please share what yours does that the /contrib doesn't, and ideally,
send in a patch or let us add your version to /contrib.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paulovič Michal 2004-03-02 19:18:07 Re: Moving from MySQL to PGSQL....some questions (multilevel
Previous Message Bruce Momjian 2004-03-02 18:45:21 Re: [GENERAL] select statement against pg_stats returns