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.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +