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 vote306 views1 answer
Sql filter rows with condition
SQL
1 vote291 views1 answer
Sql how to duplicate a table
SQL
0 vote280 views1 answer
Pip install mysqlclient error
SQL
4 votes289 views1 answer
Wildcard in sql
SQL
2 votes331 views1 answer
Python sql
SQL
0 vote295 views1 answer
Change database name psql 8
SQL
0 vote315 views1 answer
How do I insert a blob in SQL?
SQL
6 votes288 views5 answers
Mysql get last insert id
SQL
0 vote284 views1 answer
Alter table myisam to innodb
SQL
0 vote258 views1 answer
Hallo
SQL