Re: Moving from MySQL to PGSQL....some questions - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Moving from MySQL to PGSQL....some questions
Date
Msg-id 200403021857.i22Ive019767@candle.pha.pa.us
Whole thread Raw
In response to Re: Moving from MySQL to PGSQL....some questions  (Michael Chaney <mdchaney@michaelchaney.com>)
Responses Re: Moving from MySQL to PGSQL....some questions (multilevel
List 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: "Knepper, Michelle"
Date:
Subject: Re: using the "copy from" command
Next
From: Paulovič Michal
Date:
Subject: Re: Moving from MySQL to PGSQL....some questions (multilevel