Any recommendations for resources to learn postgresql stuff? Done a lot of sql with mysql. Postgres seems like quite the different beast

The official docs are useful, and https://www.postgresqltutorial.com/ is great if you need a reminder on how to do specific things. Many thing you've done with MySQL likely apply to Postgres too.