[R-sig-DB] R-sig-DB Digest, Vol 72, Issue 13

[Ajay Ohri]

Thank you  Gabor

RpgSQL did the job nicely

Regards

Ajay

Websites-
http://decisionstats.com
http://dudeofdata.com


Linkedin- www.linkedin.com/in/ajayohri




On Tue, Oct 26, 2010 at 3:30 PM, <r-sig-db-request using stat.math.ethz.ch> wrote:

> Send R-sig-DB mailing list submissions to
>        r-sig-db using stat.math.ethz.ch
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        https://stat.ethz.ch/mailman/listinfo/r-sig-db
> or, via email, send a message with subject or body 'help' to
>        r-sig-db-request using stat.math.ethz.ch
>
> You can reach the person managing the list at
>        r-sig-db-owner using stat.math.ethz.ch
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of R-sig-DB digest..."
>
>
> Today's Topics:
>
>   1. Re: [RPostgreSQL] Unable to find (Gabor Grothendieck)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 25 Oct 2010 10:56:59 -0400
> From: Gabor Grothendieck <ggrothendieck using gmail.com>
> To: Ajay Ohri <ohri2007 using gmail.com>
> Cc: r-sig-db using stat.math.ethz.ch
> Subject: Re: [R-sig-DB] [RPostgreSQL] Unable to find
> Message-ID:
>        <AANLkTimngJY0Hr_rs=m4jzu9ZGwooGt_W4CZxeru9Pmi using mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Sun, Oct 24, 2010 at 2:10 PM, Ajay Ohri <ohri2007 using gmail.com> wrote:
> > Hi
> >
> > I am unable to find R PostgreSQL ( I am on WIndows, R 2.12.0 ) via CRAN.
> >
> > Is the package still ?available and working?
> >
> > Also what are the differences between RODBC ,RPostgreSQL and RpgSQL- and
> > which one is recommended for PostgresSQL databases. ( I couldnt find rdbi
> as
> > well)
> >
> > I am using PostgreSql 9.0
> >
>
>
> RpgSQL was developed so that PostgreSQL could be used as an optional
> backend to sqldf of the sqldf package.  It was developed because the
> existing driver packages do not currently have all the features sqldf
> needed.  RpgSQL uses JDBC and so requires java.  It can also be used
> without sqldf and supports a DBI interface so its usage should be
> reasonably straight forward.
>
> There is some discussion in thel link referenced here:
> http://code.google.com/p/sqldf/#12._How_does_one_use_sqldf_with_PostgreSQL
> ?
>
> and there are examples of using it directly, i.e. without sqldf, in
> the examples section of the ?pgSQL help page:
> library(pgSQL)
> ?pgSQL
>
>
> --
> Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com
>
>
>
> ------------------------------
>
> _______________________________________________
> R-sig-DB mailing list
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
>
> End of R-sig-DB Digest, Vol 72, Issue 13
> ****************************************
>

	[[alternative HTML version deleted]]