In this chapter, you learned how to configure your local environment to work with PostgreSQL and pgAdmin. Besides that, you have also understood how to install Heroku Postgres in your application.

In addition, you have understood that the first database is created automatically when the Heroku Postgres add-on is installed in your application and there are several PostgreSQL databases as well. You also learned that the great majority of tasks can be performed in two ways: via the Heroku Client and via the Heroku dashboard.

You have also learned that Heroku Client is a very powerful tool to work with PostgreSQL; it provides a set of useful commands such as pg:info, pg:psql, pg:push, pg:pull, pg:ps, pg:kill, pg:killall, pg:promote, pg:credentials, and pg:reset.

You also looked at how to connect to your PostgreSQL database using programming and frameworks supported by Heroku, and learned how to connect to your database using pgAdmin.

Finally, you learned how to use a database that isn't...