Re: new user on mac

On Tue, Oct 18, 2011 at 2:47 PM, Scott Swank <scott(dot)swank(at)gmail(dot)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.