Re: Change owner of all database objects

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.

--
   Richard Huxton
   Archonet Ltd