So you’re using MySQL and considering a move to PostgreSQL instead? It’s easier than you think!

Migrate from MySQL to PostgreSQL

This website host reference material to help you make the switch in a painless way:

As a developer, how do I learn PostgreSQL?

The book Mastering PostgreSQL in Application Development is one of the very best resources available to lean PostgreSQL as a developer. Check it out!

Developer reference for switching from MySQL to PostgreSQL

We took the most voted StackOverflow MySQL questions and give answers to them when using PostgreSQL, so that you’ll find yourself at home right away. That’s what our FAQ below is all about.

FAQ

Can I concatenate multiple MySQL rows into one field?

How can I prevent SQL injection in PHP?

How to get a list of MySQL user accounts?

How to import an SQL file using the command line in MySQL?

How to output MySQL query results in CSV format?

How to reset AUTO_INCREMENT in MySQL?

Should I use field 'datetime' or 'timestamp'?

UTF-8 all the way through

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

Which MySQL data type to use for storing boolean values?

All FAQ