Drop a schema

If you are logged in as the admin user or you have been granted privilege to drop a schema, you can drop the schema using the DROP SCHEMA command.

You cannot drop the default schema for the database. When you drop a schema, you must specify the CASCADE (drop all objects within the schema) or RESTRICT (do not drop the schema if it contains objects). For example:

mydb.admin(admin)=> DROP SCHEMA schema_one CASCADE;
DROP SCHEMA