[gknapp]

I've used SQLWorkbenchJ on the daily for the last year and a half for postgres (on OSX). It gets a lot of flak because it's java based, can be a bit buggy, and doesn't have the nicest interface. However, if you look past those items, it has some really great features:

- DB Explorer (tab for exploring schema, allows you to search through large sets of tables and other items very easily - primo)

- SQL Formatting

- Well thought out user shortcuts for executing queries

- Intelligent auto-completion

Really, they essentially loaded it with every feature imaginable, which may make it feel clunky, but it's a total Clydesdale in terms of functionality.

http://www.sql-workbench.net/

[radiowave]

Agreed. It's not my main tool (pgAdmin usually works well enough for my purposes), but I fire up SQLWorkbenchJ once in a while when I need something that pgAdmin won't do.

Also it's scriptable data import function works nicely - we have it running here every 15 minutes, loading data from other systems into postgres.