Changer le owner des tables

#Change owner of tables qui sont à postgres

for tbl in `psql -qAt -c "select tablename from pg_tables where tableowner = 'postgres' and schemaname='SCHEMA';" dbname` ; 
do  psql -c "alter table SCHEMA."$tbl" owner to NEW_OWNER" dbname ; done