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

share|improve this question

74% accept rate
feedback

2 Answers

up vote 1 down vote accepted

See also the PostgreSQL-wiki.

share|improve this answer
feedback

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.

share|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.