MDB to PostgreSQL with mdb-tools example

gistfile1.txt

#!/bin/sh
mdb-schema Acadesc.mdb postgres | sed 's/Char/Varchar/g' | sed 's/Postgres_Unknown 0x0c/text/g' | psql -h localhost -U postgres -w -d acadesc > /dev/null 2>&1

tables=$(echo -en $(mdb-schema Acadesc.mdb postgres | grep "CREATE TABLE" | awk '{ print $3 }' | sed -e 's/"//g');)
for i in $tables
do
        mdb-export -I postgres Acadesc.mdb $i | psql -h localhost -U postgres -w -d acadesc > /dev/null 2>&1
done

#!/bin/sh
# mdb-schema xControle.mdb postgres | sed 's/Char/Varchar/g' | sed 's/Postgres_Unknown 0x0c/text/g' | psql -h localhost -U postgres -w -d acadesc > /dev/null 2>&1
mdb-schema xControle.mdb postgres | sed 's/Char/Varchar/g' | sed 's/Postgres_Unknown 0x0c/text/g' | psql -d empreendedor -U sicae_user -w -h srv-banco-new -p 5433 -v ON_ERROR_STOP=1 > /dev/null 2>&1
tables=$(echo -en $(mdb-schema xControle.mdb postgres | grep "CREATE TABLE" | awk '{ print $3 }' | sed -e 's/"//g');)
for i in $tables
do
    # mdb-export -I postgres xControle.mdb $i | psql -h localhost -U postgres -w -d acadesc > /dev/null 2>&1
    mdb-export -I postgres -q "'" -D '%d-%m-%Y %H:%M:%S' xControle.mdb "$i" | psql -d empreendedor -U sicae_user -w -h srv-banco-new -p 5433 -v ON_ERROR_STOP=1 > /dev/null 2>&1

done