Convert Mysql query to Postgresql query

Question

Is there a utility to convert a mysql query to a postgresql query?

Answer 1

See also PostgreSQL-wiki .

Answer 2

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 a tool that would automatically tune queries from MySQL to PostgreSQL.