Tools

There are a lot of tools out there to assist you when working with Postgres. Here I will list a few of the ones that I use a lot.

• psql is a command line interface for working with Postgres. I do not think it is the best place to start when learning how to query, especially if you are not comfortable with the command line. However, psql is something worth learning because of its power and ease of use.
• pgAdmin is the best desktop application out there for working with Postgres.
• explain.depesz.com is a great tool for visualizing a Postgres EXPLAIN. EXPLAIN is something you would run to investigate performance issues with your query.

If you use a tool that you would like to see on this list send me an email zach@illuminateed.com