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

0 vote142 views1 answer
How to check even or odd in sql
SQL
0 vote144 views1 answer
Group by two columns postgres
SQL
0 vote169 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote128 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
1 vote140 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote165 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote133 views1 answer
Where case insensitive like mysql
SQL
0 vote151 views1 answer
Sql values not in another table
SQL
11 votes145 views2 answers
Having in sql
SQL
3 votes145 views1 answer
Get all elements sql
SQL