Dude, seriously. I have been a developer since 2014 but I always stayed away from Postgres because it did not seem cool to me. Recently I started a company which provides Postgres deployments(ironically, just to seem cool) and that's when I unearthed a ton of incredibly powerful features in Postgres. I even wrote a small script that auto inserts user_id from users table into messages table whenever a new message is inserted into the db using Postgres triggers. I mean how cool is that.
Check it out here: https://gist.github.com/kaushik94/5257f0ff5520598e6327d14805...
Everyday I am finding more and more amazing stuff about Postgres and I'm literally obsessed.
If you want to know more about my work, connect with me here: https://twitter.com/RGraphql