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
