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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
