Everything you describe, relational databases have been doing for decades. It's not unique to Postgres.