scripts to find view list from the schema in aws redshift database?

scripts to find view list from the schema

select table_schema as schema_name,

       table_name as view_name

from information_schema.views

where table_schema  in ('app_username')

order by schema_name,

         view_name;