Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Chaney
Subject Re: Moving from MySQL to PGSQL....some questions
Date
Msg-id 20040226000923.GA12550@michaelchaney.com
Whole thread Raw
In response to Moving from MySQL to PGSQL....some questions  (Karam Chand <karam_chand03@yahoo.com>)
Responses Re: Moving from MySQL to PGSQL....some questions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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.

Michael
--
Michael Darrin Chaney
mdchaney@michaelchaney.com
http://www.michaelchaney.com/

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: reindexing, pg_class (and other system tables)
Next
From: Tom Lane
Date:
Subject: Re: key = currval('tab_key_seq') choses SEQSCAN?!