Convert Mysql query in Postgresql query

Question

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

halfdan · Accepted Answer · 2010-06-01 10:14:36Z

8

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.

answered Jun 1, 2010 at 10:14

halfdan

34.3k8 gold badges82 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jossef Harush Kadouri Over a year ago

you can also use the -d flag to get only the tables creation sql.

evtuhovdo Over a year ago

also use SET standard_conforming_strings = 'off'; SET backslash_quote = 'on'; in dump first lines

pankaj jha · Accepted Answer · 2018-05-22 09:53:53Z

5

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

answered May 22, 2018 at 9:53

pankaj jha

611 silver badge2 bronze badges

2 Comments

mivk Over a year ago

Handy if you just have a short snippet to convert. It doesn't preserve field comments from CREATE TABLE statements, however.

Azghanvi Over a year ago

It's non commercial. Any free option there?

Frank Heikens · Accepted Answer · 2010-06-01 11:05:30Z

2

Collectives™ on Stack Overflow

Convert Mysql query in Postgresql query

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related