creating a new database in postgres code example

Example 1: psql create database

CREATE DATABASE dbname;

Example 2: create database postgres

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