Sample Header Ad - 728x90

Is there a means to set the owner of all objects in a PostgreSQL database at the same time?

16 votes
5 answers
25743 views
The Stack Overflow Q & A Modify OWNER on all tables simultaneously in PostgreSQL describes some nifty ways to change table and other objects to a specific user, and it works swimmingly, however all the suggestions seem to ignore the functions I created. Is there a fairly easy way to reset the owner of ALL objects in the database, including the functions? Doing it by hand is highly undesirable.
Asked by Jeremy Holovacs (1271 rep)
Dec 24, 2011, 07:34 PM
Last activity: May 29, 2023, 08:06 AM