top of page
Shareware software
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 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