My goto these days is TablePlus https://tableplus.com. Native desktop client (no electron). UI is pretty standard, polished, and IMHO great. Supports PG really well (amongst other RDBMSes and some NoSQL dbs).
Yes it's not open source but its free version is still great.
Yes it's not open source but its free version is still great.