login-create-db-and-schema.sql

-- login, create database, create schema, and set path
-- all command=s form postgres shell

-- login on Ubuntu : sudo -u postgres psql -d postgres
-- login on MacOS  : psql -d postgres

CREATE DATABASE euro WITH TEMPLATE=template0 OWNER=postgres ENCODING='UTF8' LOCALE='C';
\c euro

CREATE SCHEMA IF NOT EXISTS league AUTHORIZATION postgres;

-- set and show schema/path
SET search_path TO league;
SHOW search_path;