Postgres change all table owner(變更table的owner)

當我們使用django 在做migrate的時候,有時會跳出錯誤訊息,關於你的relation 不存在或是不吻

合的情況下

我們就需要檢查一下settings.py下面的database user跟該database的owner和table的owner是不是

吻合,如果不吻合,那就得轉換一下owner或者是setting.py下的user要改成相對應的.

解決方法就是使用下面的script去變更owner

sometimes, we use django migrate it shows error by relation owner is not correct

because database user is not match tables owner in setting.py

so we can use this script.

for table in `psql -tc "select tablename from pg_tables where schemaname = 'public';" DATABASE_NAME` ; do psql -c "alter table \"$table\" owner to OWNER_NAME" DATABASE_NAME; done

# PLZ replace DATABASE_NAME & OWNER_NAME to what you need.