Using SQL

  • Download and install PostgreSQL

  • Download and install the pgAdmin. This is the most widely-used GUI for working with PostgresQL. It is free, open-source, and cross-platform.

  • The command line program psql should be installed, but you might need to configure your $PATH variable in order to find it.

  • dplyr provides a syntax for pulling PostgreSQL data directly into R, but relies upon the RPostgreSQL package to do so. This package is cross-platform, but is not always available as a binary.

  • Installing RPostgreSQL:

    install.packages("RPostgreSQL")

    If that doesn’t work, try:

    install.packages("RPostgreSQL", type="source")

  • Read the PostgreSQL Documentation!

etl packages