Richard,
pg_find --type=table --schema=foo --name='system_*' --execute='GRANT ALL ON % TO myuser'
Hey, that's a way keen idea. Regardless of what we do with GRANT/REVOKE. You don't happen to, uh, have any code for that?
Well, currently, what you see posted above is the full extent of the idea. If there's a feeling it'd be useful I could pull my finger out and have a working prototype ready in Perl fairly quickly. It'd take me a while to get something decent in C though.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
