← flaviocopes.com

How to create a PostgreSQL database

Published Jul 27 2021

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.