Greetings - is there any update on a PostgreSQL driver for the DBI package? If not, what's the currently-preferred method of creating a link from a PostgreSQL database and R? Thanks. ---------------------------------------------------------------------- Andrew J Perrin - andrew_perrin (at) unc.edu - http://www.unc.edu/~aperrin Assistant Professor of Sociology; Book Review Editor, _Social Forces_ University of North Carolina - CB#3210, Chapel Hill, NC 27599-3210 USA
On 12/9/05 1:10 PM, "Andrew Perrin" <clists at perrin.socsci.unc.edu> wrote:> Greetings - is there any update on a PostgreSQL driver for the DBI > package? If not, what's the currently-preferred method of creating a link > from a PostgreSQL database and R?See RdbiPgSQL: http://www.bioconductor.org/packages/bioc/1.7/src/contrib/html/RdbiPgSQL.htm l
Andrew Perrin wrote:> Greetings - is there any update on a PostgreSQL driver for the DBI > package? If not, what's the currently-preferred method of creating a link > from a PostgreSQL database and R?Some colleagues and I have been using RODBC with it successfully, from Windows and Linux machines. The Windows ODBC driver is named psqlodbc-08_00_0101.zip, but I notice on Google there's a newer one now. Not sure what you need to install on Linux. Duncan Murdoch