I don't think this will work in all cases. The index syntax is different
between mysql and psql. For example, I specify indexing in the create
clause under mysql; I use a separate statement to create an index under
psql. Am I missing something?
Thanx,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl@sandia.gov
> -----Original Message-----
> From: Michelle Murrain [mailto:mpm@norwottuck.com]
> Sent: October 19, 2000 12:46 PM
> To: David Reid
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] MySQL -> pgsql
>
>
> >Can someone point me at any resources on the web that can
> help with such a
> >transformation? I have a series of tables I want to
> convert. Thanks.
> >
> >Oh, and I'm not on the list so can you email direct! :)
>
> I don't know MySQL, but I've converted tables from mSQL to pgsql by
> just using the dump tool in mSQL (dumps the schema and data in SQL
> format into a text file), then go into psql and execute the text file
> that comes from the dump. I'm sure MySQL has a tool to do that.
>
> Michelle
> --
> --------------------------------
> Michelle Murrain Ph.D., President
> Norwottuck Technology Resources
> mpm@norwottuck.com
> http://www.norwottuck.com
>