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
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net