Convert Mysql query in Postgresql query

Question

Is there an utility to convert mysql query in postgresql query ?

Answer 1

For DDL you can use mysqldump (see http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL)

mysqldump --compatible=postgresql databasename > outputfile.sql

For DML I don't know of a tool that would automatically adjust queries from MySQL to PostgreSQL.

Answer 2

See also the PostgreSQL-wiki.