At my day job, we use MySQL and the excellent querious client to connect to it. I'm starting a side project using Postgresql, and I'm looking for a similar tool. I don't want anything too heavyweight, ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...