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

25 votes192 views6 answers
How to change column name in mysql
SQL
0 vote174 views1 answer
Mysql terminal run sql file
SQL
0 vote184 views1 answer
Sql cmd no truncate
SQL
0 vote218 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
1 vote202 views2 answers
How to add amount between date in sql
SQL
0 vote170 views2 answers
Alter table add multiple columns mysql
SQL
0 vote165 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
2 votes230 views1 answer
Creating a view SQL
SQL
7 votes199 views3 answers
Restore postgres database from sql file
SQL
0 vote172 views1 answer
Describe in sqlite3
SQL