Skip to content

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 SQL Handbook!



You might be interested in those things I do:

  • Learn to code in THE VALLEY OF CODE, your your web development manual
  • Find a ton of Web Development projects to learn modern tech stacks in practice in THE VALLEY OF CODE PRO
  • I wrote 16 books for beginner software developers, DOWNLOAD THEM NOW
  • Every year I organize a hands-on cohort course coding BOOTCAMP to teach you how to build a complex, modern Web Application in practice (next edition February-March-April-May 2024)
  • Learn how to start a solopreneur business on the Internet with SOLO LAB (next edition in 2024)
  • Find me on X

Related posts that talk about database: