[R] Mac->PgSQL

Prof Brian Ripley ripley at stats.ox.ac.uk
Fri May 12 08:36:30 CEST 2006


On Thu, 11 May 2006, Omar Lakkis wrote:

> I am writing an R application to run on Mac OS X (pentium chip) and
> connect to a PosygresSQL 8.1.3 database hosted on the same box. Could
> someone, please, recommend a library to go with for database
> connectivity?

RODBC.  There is a MacOS X binary available, and the PostgreSQL 8.x ODBC 
driver works well (at least on Linux and Windows).

> Is there a PgSQL R/DBMS  to work with DBI?

No.  BioC has Rdbi (an earlier version of DBI) and RdbiPgSQL but no MacOS 
X binaries.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-help mailing list