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/