create new schema postgres code example Example: postgresql create schema in specific database CREATE DATABASE foo; \connect foo; CREATE SCHEMA yourschema;