Configure RODBC to access the PostgreSQL database

After taking a lot of detours, I finally fixed this issue and posted it here to share with you.

1: download and install the PostgreSQL ODBC driver
Http://www.postgresql.org/ftp/odbc/versions/msi/
2: Configure ODBC to connect to the PostgreSQL database
R: how to access the database through ODBC
Download and install the RODBC package, and use the R-package-find RODBC to install it.

3: test the connection in the R Software.
> Library (RODBC)
> Channel <-odbcConnect ("PostgreSQL30", uid = "***", pwd = "***", case = "postgresql ")
> Data (USArrests)
> SqlSave (channel, USArrests, rownames = "state", addPK = ture)
> SqlSave (channel, USArrests, rownames = "state", addPK = TRUE)
> SqlTables (channel)

 

For more information, see

Http://cran.r-project.org/doc/manuals/R-data.html

Http://hosho.ees.hokudai.ac.jp /~ Kubo/Rdoc/library/RODBC/html/odbcConnect.html