#!/bin/bash

. ../rules/bash.rules

usage() {
                echo "usage : dumpData.sh -o <filename>"
		exit 1;
}

while true
do
  case $1 in
    -o) outputfile=$2
        shift 2
        ;;
    -h) usage
        exit 0
        ;;
     *)
	break
        ;;
  esac
done

if [ -z "$outputfile" ] 
then
                usage
                exit 1
fi

listOfTable=`psql -At -U ${DBUSER} -d ${DBNAME} -c "\d" -h ${DBHOST}| egrep -v "^struct" | awk -F'|' '{print $1;}'`

echo "-- Datas without scheme file" > ${outputfile}

for i in $listOfTable ; do
    echo ${DBUSER} | pg_dump -u -D -h ${DBHOST} -t ${i} -a ${DBNAME} >> ${outputfile}
    done ;

echo Done.