Welcome. Be sure to try out the transactional DDL, actual boolean and array types, functional and partial indexes, and other such features that required jumping through hoops in MySQL-land. https://www.sql-workbench.eu/dbms_comparison.html

In fact, if you've got the time, I'd highly recommend skimming through the excellent manual. You rarely know what you're missing until it's right in front of you. https://www.postgresql.org/docs/current/index.html