sidymar
5/8/2017 - 1:43 PM

Lista views do tipo materializada no BD (postgres)

Lista views do tipo materializada no BD (postgres)


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