postgresql create database terminal code example

Example 1: psql create database

CREATE DATABASE dbname;

Example 2: postgresql createdb

$ createdb -p 5000 -h eden -E LATIN1 -e demo
CREATE DATABASE demo ENCODING 'LATIN1';
/*createdb [connection-option...] [option...] [dbname] [description]*/