Re: R and postgres

I use RODBC which is available from http://cran.r-project.org/
I'm not sure if this will do what you want, or whether it has
the features of Rdbi you need, but it gets the job done for me.
I can open a "channel", execute a SQL statement (typically a Select)
and read the results back into a R dataframe.
There is a nice way to dump a dataframe back into a table which
is created for you, with columns and datatypes as appropriate.

Hope this helps.

TJ O'Donnell
http://www.gnova.com/

> I'd like to get R to talk to postgresql, but my head's spinning among a
> web of broken links, way outdated web pages, project deprecation
> announcements and a terrible signal:link ratio.
>
> Rdbi and RdbiPgSQL seem to be the answer, despite both being apparently
> defunct projects.
>
> What is the Right Thing for a guy who wants R to talk to postgresql?