Connecting to a Postgresql data base from R (Ubuntu Natty)

Just three quick steps in Ubuntu. 1. Install unixodbc and odbc-postgresql sudo apt-get install¬† unixodbc sudo apt-get install odbc-postgresql 2. Edit the blank odbc.ini file. You can just paste in the text below. The first entry is for my own local database. Change the details to match your own if you have one.¬† If you…