Re: new user on mac

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.