I recently mostly switched to Postgres from MySql, and using Postgres really points up some of the odd behavior / 'features' of MySql -- e.g., its parsing but n

I recently mostly switched to Postgres from MySql, and using Postgres really points up some of the odd behavior / 'features' of MySql -- e.g., its parsing but not enforcing check constraints, "USE database_name," disinclination to handle JSON data, etc. Also, Postgres' documentation is really fantastic. I bought a book on Postgres when I switched, but really I could have just stuck to the online manual and saved the thirty bucks. I like many things about MySql [as you imply, syntax a bit more verbose but easier to remember - e.g. "SHOW TABLES" vs "\d" ; I also like the nonstandard behavior of MySql 'GROUP BY' as it makes good sense to me ]-- but overall I'm really enjoying the flexibility of Postgres. PGadmin4, on the other hand, leaves much to be desired -- I generally stick to psql.