If convert_tz(now(),'UTC','US/Pacific') produced null do a
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
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