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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
