Convert Mysql query in Postgresql query

Is there an u开发者_JS百科tility to convert mysql query in postgresql query ?

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.

Go to http://www.sqlines.com/online select left side mysql in source past your mysql query and select right side select postgresql in target then click left side on convert button

See also the PostgreSQL-wiki.