On Tue, Oct 18, 2011 at 2:47 PM, Scott Swank <scott.sw...@gmail.com> wrote:
> 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.
