Re: changing the permission of _lots_ of tables

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