#!/bin/sh

case $# in
1) MSGID=$1 ;;
*) echo "Usage: dmmsg <msg_id>"
   exit 1 ;;
esac

dmdb -x -t -c "select subject, from_addr, msgdate from messages where msg_id=${MSGID}"

dmdb -x -t -c "set bytea_output to escape; select headers, body from messages where msg_id=${MSGID}" |
sed 's/.*| *//g' |
sed 's/\\015\\012/\n/g' |
sed 's/\\011/\t/g'