Choosing between Postgres and MySQL is hard

> MySQL is case-insensitive by default. Postgres is case-sensitive by default.

Minor quibble:

If you don't quote identifiers, they are case-insensitive in Postgres. (Case folding to lowercase by default, which ends up being a distinction without a difference.) SQL keywords are always case-sensitive. If you put double quotes around them though, the identifiers preserve case.

    SELECT * FROM "foo";

is the same as

    SELECT * FROM foo;

is the same as

    SELECT * FROM Foo;

But this next one will tell you it doesn't know which table you're talking about:

    SELECT * FROM "Foo";

Unless you made the table that way:

    CREATE TABLE "Foo" ();

In which case only the last SELECT example will work.