#! /bin/csh -f

set sunum = $1
set recnum = `echo "select  recnum from hmi_ground.lev0 where sunum = $1;\q" | psql -h hmidb.stanford.edu jsoc | head -3 | tail -1`
set FSN = `echo "select  FSN from hmi_ground.lev0 where sunum = $1;\q" | psql -h hmidb.stanford.edu jsoc | head -3 | tail -1`
show_keys ds="hmi_ground.lev0[$FSN][:#$recnum]" -p key=FSN seg=file -q -k