PostgreSQL Explained for R-Users and R-Programmers
Chapter 1 Prerequisites
For anyone interested in using this book you will need the following packages and tools to follow along.
- Your own PostgreSQL database
- Remote access to your database
The RPostgreSQL and DBI package can be installed from CRAN or Github:
Notes on using SQL syntax in RPostgreSQL
To successfully query data in PostgreSQL the following caveats may be necessary. This is especially the case if someone has created column names that are unique and odd in some form or fashion.
- use backslahes to escape the quotes "" that are necessary when querying data.
- use quotes "" around camel back title cases e.g. “Medu” or “Fedu”