Jim C. wrote:
I'm doing this table by table, line by line. Each table, I learn something new about the differences between MySQL and Postgres, I mentally catalog it and I can always look it up in my own code next time for examples. I've a tool that is providing some help but sometimes it chokes. It choked on this one for example. I could use some clues as to how to go about converting this MySQL implementation of roles to Postgres. So far I've been through 5 tables and it is getting easier but I'm still getting stuck now and then.
You probably want one of the mysql converter projects, e.g. http://pgfoundry.org/projects/mysql2pgsql/ Also read the "converting from other databases" section here: http://www.postgresql.org/docs/techdocs -- Richard Huxton Archonet Ltd
