xxxxxxxxxx
sudo su - postgres
psql -c "create database demo"
xxxxxxxxxx
# To create a new PostgreSQL database while using psql
CREATE DATABASE nameOfDatabase;
xxxxxxxxxx
For Windows users using the SQL shell
\c DB_NAME USER_NAME HOST PORT
// to get the connection details such as your username, host and port simply use the "\conninfo" command
eg : \c test1 john_doe localhost 5432