db='tracker' # UNLOAD TRACKER DATABASE echo " " > unload.sql curd=`pwd` for table in \ domain users person userauth company companyperson budget project accountsrecv \ budgetproject persbudgproj bug buglog cashdeposits cashwithdrawals work expense \ invoicelineitem { echo unloading $table... echo "copy $table to '$curd/$table.out' delimiters '|' with null as '';" >> unload.sql } psql -e -f unload.sql tracker