[R] Examples on how to READ/WRITE to database using R-Project

Robert Baer rbaer at atsu.edu
Wed Feb 21 16:33:49 CET 2007


> We are working on a project on forecast modeling and would like to know if
> there are any examples on how to READ/WRITE to a database (e.g. 
> PostgreSQL)
> using R-Project. I do have a sample R Script which takes input as files 
> from
> a directory and writes back output files to a directory.  I would like to
> convert this script to read from a database and write back the output to 
> a
> database.
> - Venkatesh Mantha
You probably want to install the RODBC package.  Then,
library(RODBC)
?RODBC

Also, the the relational database section of the R Data Import/Export Manual 
is worth reading:
http://cran.r-project.org/doc/manuals/R-data.html



More information about the R-help mailing list