Question: how to create database schema in postgresql?
Answer: First, specify the name of the schema after the CREATE SCHEMA keywords. The schema name must be unique within the current database. Second, optionally use IF NOT EXISTS to conditionally create the new schema only if it does not exist.