PostgreSQL – List materialized views

You can query the system catalog view pg_matviews to view all the materialized views.

SELECT schemaname, matviewowner, matviewname from pg_matviews;