Transforms a dump created by `pg_restore --data-only -t table db.pg_dump -f table.tsv` into a regular TSV file to be read by Spark

transform_pg_dump.sh

#!/bin/bash
for filename in *.tsv; do
    echo $filename
    tail -n +23 $filename | head -n 1 | sed -e 's/.*(\(.*\)).*/\1/' | sed -e 's/, /\t/g' > fixed/$filename
    tail -n +24 $filename | head -n -7 >> fixed/$filename
done