I needed a way to bulk alter ownerships to another user. This worked for me very well. Usage: ./pg_change_ownership dbname username

pg_change_ownership

#!/usr/bin/env bash

dbname=$1
dbuser=$2

psql -c "alter database \"$dbname\" owner to \"$dbuser\"" $dbname;

for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" $dbname`;
do
    psql -c "alter table \"$tbl\" owner to \"$dbuser\"" $dbname;
done

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

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

for tbl in `psql -qAt -c "select matviewname from pg_catalog.pg_matviews where schemaname = 'public';" $dbname`;
do
    psql -c "alter materialized view \"$tbl\" owner to \"$dbuser\"" $dbname;
done