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 vote297 views1 answer
Replace sqlalchemy
SQL
0 vote317 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote299 views1 answer
Create sample data postgresql
SQL
0 vote323 views1 answer
Sql server list table sizes
SQL
3 votes308 views2 answers
Sql random integer
SQL
0 vote327 views1 answer
Select * where id = 1,2,3
SQL
0 vote296 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote327 views1 answer
Sql server pivot rows to columns
SQL
0 vote324 views1 answer
Renombrar tabla mysql
SQL
28 votes329 views4 answers
Delete database mysql
SQL