Run the below query to list all the user defined schemas of a Redshift database:
select distinct "database", "schema" from svv_table_info where "database"='your_database_name';
Alternatively, you can list schemas by querying the pg_namespace catalog table:
select nspname from pg_catalog.pg_namespace where nspowner > 1;
