pgAdmin III 1.16 is simply to unstable, at least on Mac OS X 10.9. However after multiple crashes within short time I decided to look further.

I didn’t like the Java UI that much but it was acceptable. First I thought it looked nice, with reasonable performance. Then the list diminished further when I removed all Windows tools. I scratched all of the browser based tools actually. This tool maybe can do a lot, but I was simply to lazy to install it on my VM when there should be tools which “just work”. I have used its brother for MySQL, phpMyAdmin, when I was younger or when I just need some basic features. My preference is a tool which just does on thing right. I haven’t tried what LibreOffice or can do with PostgreSQL. As a IntelliJ user I could have used the IDEs database features, but honestly I don’t like them that much (same with SCM).

I dropped all tools from the list which were embedded in other huge tools. With this list in mind I checked some recommendations from PostgresQL.

Optionally some tool to visualize my structure.

I made up a list what I expect from my client: It was my first project using PostgreSQL so I had no tool around to work visually with it. With my latest project I had to work with Vagrant and PostgreSQL.

Navicat for postgresql