[PostgreSQL] change owner

change-owner

#!/bin/bash

for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" [db-name]` ; do
  psql -c "alter table $tbl owner to \"[db-user]\"" [db-name] ;
done

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