Differences between Postgresql and Mysql?

Question

MySQL

Are Postgresql and Mysql very different?
Is it difficult to import a database from Mysql to Postgresql?
Will there be many differences in SQL commands at the level of program code?

Answer 1

Both support SQL, but have their own additions to it. Google - there are many comparative articles.
Usually cosmetic changes to the dump are required. There are many converters for this.
To make the code work the same with any database, use abstractions like ORM/ActiveRecord

Answer 2

The most important difference is that PostgreSQL supports the modern SQL:2008 standard, while MySQL does not fully support even SQL-92.

Answer 3

If you're migrating from MySQL to Postgres, it shouldn't be too hard - there are plenty of automatic migration converters for that. The only thing that will break is that it should not have worked
anyway :) In the opposite direction, difficulties are possible, after all, postgres has many features that are not familiar to mysql or are written differently.

Answer 4

https://www.postgresql.org/docs/9.6/static/tutoria...