Re: [R] postgres

About this list Date view Thread view Subject view Author view Attachment view

From: Andrew Perrin (clists@perrin.socsci.unc.edu)
Date: Wed 12 Feb 2003 - 08:34:35 EST


Message-id: <Pine.LNX.4.21.0302111632560.21972-100000@perrin.socsci.unc.edu>

Yes, I do. Here's a code snippet that worked for me:

library(RPgSQL)
db.connect(dbname='fgdata')
fgdata.df<-db.read.table('mlm_data')

This assumes you have the RPgSQL library installed, and that you have
postgres running on the local machine. There's more documentation in the
RPgSQL package.

Best,
Andy Perrin

----------------------------------------------------------------------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu

On 11 Feb 2003, Joshua Gramlich wrote:

> Is anyone using R with postgres? I'd like to do so, but cannot seem to
> find any reasonable explanation of how to do so.
>
>
> Joshua Gramlich
> Chicago, IL
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help
>

______________________________________________
R-help@stat.math.ethz.ch mailing list
http://www.stat.math.ethz.ch/mailman/listinfo/r-help


About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Tue 01 Jul 2003 - 09:11:21 EST