I have posgres up and running, and can create a database in psql using the postgres user. I also created a web user using the createuser command. Then in a perl script I say use DBI;and then try ...

If Postgres lives on your local machine and in your personal and team clouds, and hosts Python or R, you can query with SQL and use those languages (and their extensive libraries!) for the special ...