#!/bin/bash

for table in `echo "SELECT relname FROM pg_stat_all_tables;" | psql dbname | grep -v "pg_" | grep "^ "`;
do
    echo "GRANT ALL ON TABLE $table to username;"
    echo "GRANT ALL ON TABLE $table to username;" | psql dbname
done