resumable gigantic csv importer for postgresql. csv column count must match with your table

import.sh

#!/bin/bash

## usage:
## >import.sh filename.csv table database

folder=__csv
mkdir $folder
split -l 10000 $1 $folder/part
cd $folder
psql -c "copy $2 FROM 'partaa' DELIMITER ',' CSV HEADER;" $3;
rm partaa
for x in $(ls part*); do
echo "importing: $x";
psql -c "copy $2 FROM '$x' DELIMITER ',';" $3;
rm $x
echo "remaining blocks:";
ls | wc -l
done
echo 'completed';