Re: Change owner of all database objects

On Jan 18, 2006, at 4:02 AM, Richard Huxton wrote:

> Andrus wrote:
>> Currently all my database objects are owned by superuser postgres .
>> I need to change owner to a nonprivileged role for all objects in
>> a database.
>> I'm using Postgres 8.1 server and client in Windows XP, only
>> plpSQL language installed in server.
>
> Search the mailing list archives. I seem to remember solutions
> involving shell and perl (and you could install perl if you wanted)
> but I think also something in plpgsql.


You can find some plpgsql functions here:

http://pgedit.com/tip/postgresql/access_control_functions


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL