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.
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.
- 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/