How to list all views in a Redshift database

Run the below query to list all the non-system views in a Redshift database.

select table_schema, table_name from information_schema.views 
where table_schema not in ('information_schema', 'pg_catalog') 
order by schema_name;
See also  How to Rename a user in Redshift database