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;