#!/bin/sh
# $1 -> privilege(s)
# $2 -> rolename
# $3 -> dbname

psql -U postgres -t -c "SELECT 'GRANT $1 ON public.' || t.relname || ' TO $2;' from pg_class t, pg_namespace s WHERE t.relkind IN ('r', 'v', 'S') AND t.relnamespace=s.oid AND s.nspname='public';" $3 
#| psql $3