Database Administration & Monitoring
Re-assigning all objects from on role to another in PostgreSQL
31.07.2017 by Daniel Westermann
From time to time it might be required to move objects (tables, indexes, whatever) from one user to another user in a database system. You could do that by dumping all the objects with pg_dump and then(…)