Re: [R-sig-Geo] [R] Connecting to PostgreSQL/PostGIS from R (rgdal?)

2007-06-02 Thread Tim Keitt
My Rdbi (+Rdbi.PgSQL) package was written to be much simpler and easier to use than either DBI or RODBC. Unfortunately, I do not have time to maintain it, so I'm not sure what state it is in. Either DBI or RODBC should work fine for pushing tables back and forth. RODBC is probably the most up-to-da

Re: [R-sig-Geo] [R] Connecting to PostgreSQL/PostGIS from R (rgdal?)

2007-06-02 Thread Edzer J. Pebesma
Mike, my experience with linking R with PostGIS are documented here: http://wiki.intamap.org/index.php/PostGIS which I may have mentioned before on r-sig-geo. Indeed, as Tim confirms, besides the (r)gdal link, (R)ODBC is another working link for transferring table information. I doubt whether i