postgres grant to all tables

select 'grant all on '||schemaname||'.'||tablename||' to bar;' from pg_tables where schemaname in ('baz', 'quux') order by schemaname, tablename;

taken from: http://bensbrain.blogspot.com/2004/08/postgres-grant-on-all-tables-in.html