Archives
Categories
Tag Archives: greenplum
Horizontal Paging of Greenplum or Postgres Queries
When using gpsql or pgsql to query greenplum or postgres respectively, query results which exceed the width of your term will wrap in a very annoying fashion. To get horizontal paging, set the environmental variable PAGER: export PAGER=’less -RSFX’ then … Continue reading
Querying Postgres or Greenplum From R on a Mac, Installation Instructions
NB: this works on 64b versions of R; I tested it with the R64 app with R version 2.10.1 on Snow Leopard Step by step instructions for talking to Postgres or Greenplum: install macports install postgres; I used 8.4 sudo … Continue reading
Querying Databases From R on a Mac
I use a mac, currently running OS 10.6 / Snow Leopard, and I’d like to query our greenplum / postgres database from R. This used to work with R 2.9, but I unfortunately had to upgrade R, and R 2.10 … Continue reading
Posted in Data Munging, R, R Tip
Tagged greenplum, postgres, R and Databases, R Tips
Leave a comment
Querying Postgres or Greenplum from R on a Mac
So, I’m using snow leopard, and I want to query our postgres / greenplum database. First things first: I’m familiar with the RODBC package on CRAN. This installs fine, since it’s a binary package. I also installed the ODBC Administrator … Continue reading
Posted in Data Munging, R, R Tip
Tagged greenplum, postgres, R and Databases, R Tips
Leave a comment
Querying Databases in R, on Mac OS
Unfortunately, it appears with the recent release of 10.6 / Snow Leopard Apple has removed the ODBC Administrator Tool from the OS. It can still be downloaded from Apple.
Querying Databases in R
One of the first things you’ll want to do in R is set it up to talk to databases. The easiest way to do this is using ODBC, via package RODBC. To get the package, run > install.packages(RODBC) Once you … Continue reading
Posted in Data Munging, R, R Tip
Tagged data frame, greenplum, mysql, postgres, R and Databases, R Tips
Leave a comment
