Do postgresql

DO $$DECLARE r record;
BEGIN
    FOR r IN SELECT table_schema, table_name FROM information_schema.tables
             WHERE table_type = 'VIEW' AND table_schema = 'public'
    LOOP
        EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';
    END LOOP;
END$$;

Source: postgresql.org

Similar codes

28 votes292 views6 answers
Sql update
SQL
0 vote252 views1 answer
Mql5 list all available symbols
SQL
7 votes265 views2 answers
Execute mysql file
SQL
0 vote250 views1 answer
Mysql error codeigniter
SQL
15 votes252 views2 answers
Sql order by multiple columns
SQL
1 vote278 views1 answer
Sql where max date
SQL
0 vote251 views1 answer
Sql string length postgresql
SQL
0 vote271 views1 answer
Postgres set default schema
SQL
2 votes266 views1 answer
Columns Present in a table
SQL
1 vote236 views1 answer
Postgresql update auto_increment value
SQL