Horizontal Paging of Greenplum or Postgres Queries
Filed in Data Munging, January 26, 2010, 5:58 pmWhen 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 either in your psql or gpsql session, or in your .psqlrc file,
\pset pager always
Note that if [...]
Interactive Plotting in R
Filed in Uncategorized, January 25, 2010, 2:53 pmThere are many ways to compare univariate distributions; one of my favorites is violin plots. However, if you are only comparing two distributions, then the best solution is often a scatter plot. To that end, I’ve build some code that creates an interactive scatter plot of two distributions and allows you to interactively [...]
Querying Postgres or Greenplum From R on a Mac, Installation Instructions
Filed in Data Munging, R, R Tip, January 21, 2010, 2:19 pmNB: 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 port install postgresql84
in a shell, create an environmental variable PG_CONFIG pointing to the pg_config binary installed [...]
Querying Databases From R on a Mac
Filed in Data Munging, R, R Tip, January 11, 2010, 5:28 pmI 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 on the mac is a 64 bit app. So, I want to use [...]
