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

Posted in Data Munging | Tagged , | Leave a comment

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

Posted in Data Munging, R, R Tip | Tagged , , | Leave a comment

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 , , , | 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 , , , | 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.

Posted in Uncategorized | Tagged , , , | Leave a comment

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 , , , , , | Leave a comment