MySQL is case-insensitive by default. Postgres is case-sensitive by default. MySQL allows to join tables from different databases. Postgres can only join tables inside a single database, unless using the FDW extension. Operability Due to the underlying storage engine design, Postgres has an infamo...
> The problem is it's not case-insensitive; it's case sensitive with unwanted > conversion to lower case. This makes problem with database-independent > applications. > > Details: some databases are case-sensitive and some are not. In order to > avoid problems, we write all table and c...
In the past, I think PostgreSQL ranked pretty poorly in these areas - e.g. it didn't work natively on Windows, had to compile yourself, wasn't available on many shared hosts (still is case, but the story is getting better), and it had some pretty annoying user-friendly problems (it ...