create a new schema in postgres and tables code example

Example: postgresql create schema in specific database

CREATE DATABASE foo;
 \connect foo;
 CREATE SCHEMA yourschema;