Andreas, Richard,
Thanks. The link below is like of what I was looking for if there
wasn't an already written script. been through all three of my Pg books
but didn't find any mention of this type of scripting.
Rod
--
A. Kretschmer wrote:
am Wed, dem 13.12.2006, um 7:55:48 +0000 mailte Richard Huxton folgendes:
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.
Perhaps this one:
http://people.planetpostgresql.org/greg/index.php?/archives/38-Scripting-with-psql.html
Regards, Andreas
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
