How to create a PostgreSQL database

Jul 27, 2021

Learn how to create a PostgreSQL database by opening the console with psql postgres and running the CREATE DATABASE command, then list it to confirm.

~~~

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.

~~~