Linuxのsendmailを使ってテーブルを監視

例えば、PostgreSQLコマンドの実行結果をメール送信する

sample.sh

#! /bin/bash

PG_USER=""
PG_PASSWORD=""
PG_HOST=""
PG_PORT=""
DB_NAME=""

export PGPASSWORD=$PG_PASSWORD
IFS=','

date_now=`date +"%Y-%m-%d %k:%M:%S.%3N"`

GET_USER_SQL="
SELECT 
  id, name 
FROM 
  user;
"
GET_POST_SQL="
SELECT 
  user_id, content 
FROM 
  post;
"

result=`psql -U $PG_USER -h $PG_HOST -p $PG_PORT -d $DB_NAME <<_EOD
   \timing
   $GET_USER_SQL
   $GET_POST_SQL
_EOD
`

MAILING_LIST=(
  [e-mail]
  [e-mail]
)
SUBJECT="Excute Result"

mail_body=`
echo
echo date_now
echo $result | sed -e '1,1d'
`
echo -e "Subject: $SUBJECT \n\n $mail_body"  | sendmail ${MAILING_LIST[*]}