ALTER owner to tables, sequences and views on PostgreSQL databases using bash

owner_to.sh

#!/bin/bash

DB=[YOUR_DB_NAME]
OWNER=[NEW_OWNER]

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

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

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

#set timezone
psql -c "ALTER DATABASE\"$DB\" SET timezone TO 'Africa/Nairobi';" $DB

Does this grant privileges on all table to the user

Yeah. The first one for tables, then for sequences then for views. Respectively. It'll loop through the various database objects

I've corrected a minor error on # alter tables owner, It was missing the backticks (`)