Roderick A. Anderson wrote:
Works great ... up to a point. I now need to change the users and owners associated with all the tables without changing their permissions.Is there a way or hack to do mass changes like these.
Write a small plpgsql function to take a pattern and set permissions based on that. A quick bit of googling should find some examples for you.
-- Richard Huxton Archonet Ltd