Bulk change table owner in postgres
Published On September 29, 2015
How to modify the owner of many tables in a PostgreSQL database?
While there is a command REASSIGN OWNED to change the ownership of database objects owned by a database role, sometimes you need to change the owner of some tables only.
This is the script I run from pgAdmin.
Tags: postgres dba sql