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.
I'm thinking about the following possibilities:
1. Create a loop over all database objects and issue change owner statements
2. Update system tables.
3. Make database dump and restore
4. make text dump and run some global find/replace. I'm not sure which
utility can handle it in windows
Is there any sample how to do it in Windows ?
Andrus.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
