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

for TT in $(mdb-tables *.mdb); do
mdb-export -D '%%Y-%%m-%%d %%H:%%M:%%S' *.mdb "$TT" > "${TT}.csv"
done

non comparably faster:

mdb-export -H -Q -q "'" $access_db_file $table | psql -d $postgres_db -c "COPY $table from STDIN with null as ''

text fields with "bad" symbols need additional work