postgresql.R

# Connecting using RPostgreSQL works
library(RPostgreSQL)
con <- dbConnect(dbDriver("PostgreSQL"),
                 host = "localhost",
                 dbname = "postgres",
                 user = "postgres",
                 password = password,
                 port = 5432)
                 

# Connecting with odbc not working (probably wrong parameters)
con <- DBI::dbConnect(odbc::odbc(),
                      Driver   = "PostgreSQL Driver",
                      Server   = "localhost",
                      Database = "postgres",
                      UID      = 'postgres',
                      PWD      = password,
                      Port     = 5432)
                      
# Error: nanodbc/nanodbc.cpp:950: IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified