X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fbuilder.sh;fp=sql%2Fbuilder.sh;h=221bd870b9b6715e63c2a86d401ab5f0cc81f567;hb=9cbf3bfaad0cad7feaf6413eb53df0a1475c6303;hp=0417a058bee9c60b2ecf1f138d6115ced4036738;hpb=312a6acc00ec7f331ab461894c319776eec95cae;p=brisk.git diff --git a/sql/builder.sh b/sql/builder.sh index 0417a05..221bd87 100755 --- a/sql/builder.sh +++ b/sql/builder.sh @@ -65,7 +65,9 @@ elif [ "$1" = "rebuild" ]; then echo "-- MESG: build start" ; one_or_all $2 | grep -iv '^drop' ; echo "-- MESG: build end" ; ) \ | sqlexe $sht elif [ "$1" = "psql" ]; then - psql -h $DBHOST -U $DBUSER $DBBASE + psql -h $DBHOST -U $DBUSER $DBBASE $@ +elif [ "$1" = "piped" ]; then + psql -h $DBHOST -U $DBUSER $DBBASE -t -q -A -F '|' $@ elif [ "$1" = "dump" ]; then if [ $# -eq 1 ]; then pg_dump -a --inserts -h $DBHOST -U $DBUSER $DBBASE @@ -88,6 +90,7 @@ else echo " ./builder build" echo " ./builder rebuild" echo " ./builder psql" + echo " ./builder piped" echo " ./builder add " echo " ./builder dump [dumpfile]" echo " ./builder dumpall [dumpfile]"