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