Take it up a notch? Write a script which takes the dbname and the
script name:
/pcode/
#!/bin/bash -e
if [[ $# -ne 2 ]]; then echo "missing arg(s)"; exit 2; fi
dbn=$1; shift;
sql=$1; shift;
psql --dbname $dbn --file $sql
/pcode/
I thought of that, yet so earnestly want avoid Yet Another Tiny Script.
Isn't it a toss-up with putting the check in every sql script?
Or make it /really/ fancy: use proper arg parsing; check for existence
of the sql script; add a usage function; split stdout/stderr... No end
of fun.
