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

1 vote291 views1 answer
Oracle split string
SQL
0 vote306 views2 answers
How to install mssql on mac
SQL
0 vote310 views1 answer
Connect by query in oracle
SQL
0 vote294 views1 answer
Mysql set column equal to another automatic
SQL
0 vote274 views2 answers
Sql query unique
SQL
0 vote284 views2 answers
Get all index postgres
SQL
15 votes283 views2 answers
How to know the username of postgresql
SQL
11 votes318 views1 answer
Creating tables in sql with python
SQL
2 votes302 views1 answer
Mysql last 7 days including today
SQL
0 vote283 views1 answer
Postgres truncate with cascade
SQL