PostgreSQL script to reassing db owner. http://stackoverflow.com/questions/1348126/modify-owner-on-all-tables-simultaneously-in-postgresql

postgres_reassign_owner.sh

#!/bin/sh

YOUR_DB='mydb'
NEW_OWNER='new_owner'
for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" $YOUR_DB`;
do
    psql -c "alter table $tbl owner to $NEW_OWNER" $YOUR_DB;
done

for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" $YOUR_DB`;
do
    psql -c "alter table $tbl owner to $NEW_OWNER" $YOUR_DB;
done

for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" $YOUR_DB`;
do
    psql -c "alter table $tbl owner to $NEW_OWNER" $YOUR_DB;
done