Hi Tiago,
It works for me on Mac.
What PostgreSQL version are you using?
Here's the query used to get the list of views:
SELECT
cl.oid
, cl.relname AS viewname
, ns.nspname AS SCHEMA
, pg_get_viewdef( cl.oid ) AS definition
, obj_description( cl.oid ) AS COMMENT
, ( CASE
WHEN cl.relkind = 'm'
THEN TRUE
ELSE FALSE
END ) AS "materialized"
, ( CASE
WHEN cl.relkind = 'm'
THEN( SELECT ispopulated FROM pg_matviews WHERE schemaname = ns.nspname AND matviewname = cl.relname )
ELSE FALSE
END ) AS with_data
FROM pg_class cl
JOIN pg_namespace ns
ON ns.oid = relnamespace
AND ( cl.relkind = 'v' OR cl.relkind = 'm' )
AND ns.nspname = 'schema_name'
You can try it to see if materialized views are returned for your
schema_name.
.
