For someone that is using c# , please have a look at the excellent Marten library that shows the awesome functionality of Postgress as a document ( eg. NoSql) + event store.

Postgres is not only for Sql, as I see multiple people referencing only the SQL functionality.

For those that work with events/projections, Postgress supports js migrations on events so you can update events in you store to the latest version.