RE: MySQL -> pgsql

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(at)sandia(dot)gov

> -----Original Message-----
> From: Michelle Murrain [mailto:mpm(at)norwottuck(dot)com]
> Sent: October 19, 2000 12:46 PM
> To: David Reid
> Cc: pgsql-general(at)postgresql(dot)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(at)norwottuck(dot)com
> http://www.norwottuck.com
>