#!/bin/sh -eux
db="$1"
schema="${2:-$db}"
owner="${3:-$schema}"
sudo -u postgres psql "$db" -a -f - --set ON_ERROR_STOP=1 <<-EOF
	DO LANGUAGE plpgsql \$\$
	BEGIN
		IF NOT EXISTS (
		 SELECT *
		 FROM pg_catalog.pg_namespace
		 WHERE nspname = '$schema'
		 LIMIT 1
		) THEN
			CREATE SCHEMA $schema
			 AUTHORIZATION $owner;
		END IF;
	END;
	\$\$;
	EOF