create database psql command line code example

Example 1: psql create database

CREATE DATABASE dbname;

Example 2: create database postgres

createdb -h localhost -p 5432 -U postgres testdb
password ******

Example 3: postgresql createdb

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