Re: Postgres SQL Syntax

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