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

​

Menu

• Copy name - copy the name of the materialized view to the clipboard

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

• Get DDL - generate 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