I love Postgres! I've barely scratched the surface compared to you and I found Postgres a pleasure to use when building a solution around it recently, so I'd say even at the basic use/novice end of things it's superior to say SQL Server or (gulp) Oracle, which are the other databases I've had experience of.

I use Python to orchestrate and read SQL scripts from disk which I then write my dynamic variables into, and then pump that into Postgres with psycopg2, and the whole thing's been running perfectly for a couple of years now. Probably a hacky way to do things but it's all offline so I have the luxury of not worrying about security.