It kinda always baffled me that MySQL always had better (free) GUIs (MySQL WorkBench) while what was in my opinion (and nowadays I think most others) didnt have any good ones
There were always some commercial GUIs for PGSQL, but the free or opensource ones were very bad
PgAdmin is very bad in my opinion, functional, but .. i guess i never really liked that it was web based, it felt slow and clunky and the aesthetics were off
Now Azure Data Studio have a PG Plugin, I didnt try it yet, but I used Azure Data Studio for MS SQL, and I am starting to like it a lot, I do hope Azure Data Studio continue to support many more DBMSes and hope that it get more adoption and support for PGSQL and from the PGSQL community
EDIT
One more thing I want to mention, Azure Data Stuido, have a feature that currently only support MS SQL, its the database project
In a DB Project on ADS (Azure Data Studio), you work on your DB declaratively , i.e. you work on a SQL script that describe your table or other objects (A Create Statement) and the Poject tooling auto generation to alt and deployment scripts by comparing changes vs target , you can deploy directly from ADS or generate a dakpac to be executed as part of your CI/CD
Also since all you code is simple .sql file you can easily use source control
All other tools mentioned below have nothing that come close, not even DataGrip from Jetbrain
I do hope that MS will add support for other DBs to their Database Project feature in ADS, its an amazing feature, and the only way one should work on a DB
postgres has some cool tools these days. postico if you are on macos or my personal fav lately has been https://www.beekeeperstudio.io/ which is also multi-db
Sequel Pro is the one I keep comparing all Postgres clients to.
Beekeper is nice but lacks some of the GUI Tools, there's no point in having a nice GUI but not any good amount of functionality.
At times I see folks new to Postgres using 2 or 3 different GUIs to do different things.
sequel pro (which afaik has not been updated since 1928?) could be compared with postico2 as far as native look and feel go - https://eggerapps.at/postico2/
never realized sequel pro was open source: https://github.com/sequelpro/sequelpro