*change*.sh

#!/bin/bash
# change table owners for a databse - postgresql

ALTER DATABSE dbname OWNER TO username;

for tbl in $(psql -qAt -c "SELECT TABLENAME FROM pg_tables WHERE schemaname = 'public';" $DATABASE);
do
    psql -c "alter table $tbl owner to $NEW_OWNER" $DATABASE ; done

done