-- Simple create
CREATE DATABASE dbname WITH OWNER dbowner ENCODING='UNICODE';

-- Create from a template
CREATE DATABASE dbname WITH OWNER dbowner ENCODING='UNICODE' TEMPLATE=sourcedb;

-- Simple create
CREATE DATABASE dbname WITH OWNER dbowner ENCODING='UNICODE';

-- Create from a template
CREATE DATABASE dbname WITH OWNER dbowner ENCODING='UNICODE' TEMPLATE='sourcedb';

CREATE DATABASE dbname WITH OWNER dbowner ENCODING='UNICODE';

Create database in PostgreSQL

SQL