(re)Create PostgreSQL databases from a bunch of .sql.gz dumps

pgsql_import_all.sh

#!/bin/bash

# (re)Create PostgreSQL databases from a bunch of .sql.gz dumps

DBHOST=localhost
DBUSER=root

for f in *.sql.gz
do
  echo "Unpacking $f ..."
  gzip -d $f
done

for f in *.sql
do
  echo "Processing $f file..."
  dbname=$(basename "$f" .sql)
  psql -h $DBHOST -U $DBUSER -d postgres -c "DROP DATABASE $dbname"
  psql -h $DBHOST -U $DBUSER -d postgres -c "CREATE DATABASE $dbname WITH ENCODING 'UTF8'"
  psql -h $DBHOST -U $DBUSER -d $dbname -f $f
done