How to create a PostgreSQL database

When you have PostgreSQL installed you can create a new database by opening the console with:

psql postgres

and then running the command CREATE DATABASE:

CREATE DATABASE databasename;

Don’t forget the semicolon ;

You’ll then see the newly created database by running the \l command.

Download my free Programming Ebooks!