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;
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;