Listando todas views de um banco de dados PostgreSQL
select
schemaname,
viewname
from
pg_catalog.pg_views
where
schemaname NOT IN (
'pg_catalog', 'information_schema'
)
order by
schemaname,
viewname;
Fonte: https://database.guide/how-to-list-all-views-in-a-postgresql-database/