Топ-100
 
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.jpg
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