take a look at PostgreSQL Migrating from other Databases to PostgreSQL. There are quite a few references which deal with migrating MySQL to PostgreSQL. Note that any of them refer to older versions of PostgreSQL, so don't take the exact directions literally. They do a good job of describing how to perform the job, but unless you're running an outdated version of PostgreSQL (and if you are, you shouldn't be) treat them as general guidelines.
For instance, I recommend pgAdminIII, which comes with PostgreSQL v8, rather than psql. Later versions also have additional functionality.
I also believe (verify at the postgresql.org site) that there's an add-on project so that individuals could add some of MySQL's non-standard functions and views to Postgresql, to make migration easier.
Last edited by loquin; 11-17-06 at 11:52.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert