A preliminary release of my postgres package for R is at
http://www.nceas.ucsb.edu/~keitt/R/postgres.tgz
It allows one to read and write data frames to and from a postgres
database, execute queries and has an experimental "proxy" interface
that
allows you to access postgres tables using the standard, local data
frame model. All accesses to the data frame generate the appropriate
queries and returns the data from the database. (The proxy interface is
broken at the moment.) I'm mostly looking for a few testers (hopefully
with postgresql experience) to try it out.
Cheers,
Tim
--
Timothy H. Keitt
National Center for Ecological Analysis and Synthesis
735 State Street, Suite 300, Santa Barbara, CA 93101
Phone: 805-892-2519, FAX: 805-892-2510
http://www.nceas.ucsb.edu/~keitt/
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-announce mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-announce-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Neat. I assume you know that Michael Lapsey is preparing a general ODBC interface? Anyway, as I currently use a simple R function around a system call to psql, combined with read.table, I thought I'd give a shot, but alas:> library(postgres)Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/usr/lib/R/library/postgres/libs/postgres.so": /usr/lib/R/library/postgres/libs/postgres.so: undefined symbol: PQfsize Platform is Debian GNU/Linux with R 0.65.1, and postgresql 6.5.2. Regards, Dirk -- According to the latest figures, 43% of all statistics are totally worthless. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._