I've found DBeaver [1] to be a good replacement after giving up with pgAdmin3 (I did love pgAdmin2, however).
Datagrip is also fine if you're a Jetbrains user.
Datagrip is also fine if you're a Jetbrains user.
I hop into the native apps for more complex, database specific features (GIS etc) but generally it’s perfect.
I don't have any GUI client installed now. I ssh to servers and use psql there. I use psql locally and inside docker containers. I used pg-cli (?) years ago but I probably lost it during one of the various reinstalls (usually one for each Ubuntu LTS, I'm on Debian now) and I forgot about it.
I am using it on a daily basis and it's very powerful, but it shoves all the complexity at your face, it doesn't scale down. And it uses ~7% of my M1 CPU while sitting there unused, not even connected to any DB.
Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer