[booty]

All I really want from a database IDE is awesome autocomplete for identifiers and keywords. (I consider SQL Server Management Studio's autocomplete to be great - if I could get that for Postgres, I'd be thrilled)

You can get part of the way there by Sublime Text to run queries and browse results. In Sublime, it's easy - you can create a custom "build tool" with (essentially) just one line of config... you're basically just piping the current file's contents to command-line PSQL: https://www.youtube.com/watch?v=tPd4m3PLVqU

Then I use the SublimeAllAutocomplete package. It works just like "regular" Sublime autocomplete except it gives you autocomplete suggestions from all open files, not just the current one - so if you have your DB schema dump in another window it will use that: https://github.com/alienhard/SublimeAllAutocomplete

Obviously, that doesn't really give you the smartest autocomplete ever but it's pretty productive for me. Tons of room for improvement though.

[asnyder]

Has auto-complete and everything: http://www.sqlmanager.net/products/postgresql/manager