#!/bin/bash db=data4impact host=localhost port=5432 user=d4i passwd= DIR=$(cd "$(dirname "$0")/.."; pwd -P) PGPASSWORD=$passwd psql -h $host -p $port -U $user $db -f $DIR/lib/refreshMaterializedViews.sql