top of page
Волнистый абстрактный фон
CerebroSQL

MATERIALIZED VIEW node for PostgreSQL

List of materialized views in the selected PostgreSQL database schema. The list can be filtered by entering part of the table name in the " Like name object " field

PostgreSQL Materialized view list in schema
Menu
  • Copy name- copy the name of the materialized view to the clipboard

  • Refresh mat view- generate a command to update the data in the materialized view

  • Get DDL- form a command to create a materialized view

  • Data- show data

List of materialized views

SELECT oid,
      relname as "Name"
 FROM pg_catalog.pg_class
 where relnamespace = (select oid 
                         from pg_catalog.pg_namespace  
                         where nspname =  $$SCHEMA)
   and relkind in ('m')
 order by 2 


Get DDL

select definition 
 from pg_catalog.pg_matviews m 
where schemaname = $$SCHEMANAME 
   and matviewname = $$MATVIEWNAME 

bottom of page