I use intelij personally (for work and personal development). They also have a standalone product, DataGrip (
https://www.jetbrains.com/datagrip/) with affordable/free pricing.
In the past I've just used raw psql from the console, but having an IDE is a big quality of life improvement IMO.