Lista views do tipo materializada no BD (postgres)

5/8/2017 - 1:43 PM


select 'REFRESH MATERIALIZED VIEW' || ' ' || 'previsao.' || relname 
from pg_class where relkind = 'm' and relname ilike '%vw_mat_onda%'

Cacher is the code snippet organizer for pro developers