I use pgAdmin III Some features I like: * You can highlight code in the Query window and hit play and it only runs the highlighted code. * You can export que

I use pgAdmin III Some features I like: * You can highlight code in the Query window and hit play and it only runs the highlighted code. * You can export query results to CSV easily from the Query window File Menu. * Stores history of commands run, can run them again with a click ("Previous queries" in Query window). * Not all options are available by default. File > Options > Browser > Display to show more stuff. * Can run EXPLAIN with a click. I also sometimes use IntelliJ IDEA Ultimate which has a good SQL editor