Change the owner for objects in a Postgres schema
Objects in Postgres can trivially have their ownership re-assigned, e.g.: alter table test_table set owner to gary; You can also trivially re-assign ownership of all objects a user owns: REASSIGN OWNED BY test_user TO gary However, you can’t list all objects in the same way, and there is not a simple way to change the …
Continue reading “Change the owner for objects in a Postgres schema”