There are 3 ways to list all schemas available in PostgreSQL: by using SQL Query, psql command or by using ERBuilder data modeler you can visualize all the available schemas (except the empty ones)

The query below allows you to create a SCHEMA on your Amazon Redshift instance using the AWS query editor. In this example we will create a SCHEMA named "New_Schema" and gives ownership to the default user "dbuser"

On this post you will learn how to set up your first AWS Redshift database. The queries below allow you to create, delete, alter, and list a database on your Amazon Redshift