I have a postgres 9.1 database up & running, no problem. Purely in terms of writing sql (ddl, dml & pg/plsql), what tools are recommended?
Coming from an Oracle world, I'm thinking of toad, sql developer, etc.
1. psql & text editor of choice (if so, which one?)
Count me as one who has never felt the need for anything other than terminal window, vim/emacs, a browser with the postgresql docs, and the psql client. I used pg_dump to get create statements if I need them, but mostly just the \d command in psql to show me table structure without create statements. It is definitely worth exploring the various meta-commands in psql in order to learn what is available. Most of the psql documentation is devoted to them - http://www.postgresql.org/docs/9.0/static/app-psql.html Even if you use pgAdmin, you'll be much better off if you know how to do more than just the basics in psql.