Skip to main content

Creating a database

Welcome to this tutorial! Here, we will be learning how to create a database using PostgreSQL, a powerful, open-source object-relational database system. This tutorial is beginner-friendly, so don't worry if you're just starting out. We'll cover all the basics and guide you through the process step by step.

Prerequisites​

Before we dive in, make sure that you have the following:

  • PostgreSQL installed on your machine. If you haven't installed it yet, you can download it here.
  • Basic knowledge of SQL is beneficial, but not necessary. We will cover everything you need to know.

Starting PostgreSQL​

To start PostgreSQL, you need to access the PostgreSQL interface, also known as psql. This can be done by opening your terminal and typing the following command:

psql -U postgres

In this command, -U stands for "user" and postgres is the default username. After running the command, you'll be asked for your password. Enter your password and press Enter.

Creating a Database​

Now that we're in psql, we can create a new database. The command for this is CREATE DATABASE, followed by the name of the database you want to create. For example, if we wanted to create a database named my_database, we would use the following command:

CREATE DATABASE my_database;

Don't forget to end your command with a semicolon (;)!

After running this command, PostgreSQL will create a new database named my_database and you'll see the following message:

CREATE DATABASE

This means that the database was created successfully.

Accessing the Database​

To use your new database, you need to connect to it. You can do this with the \c command, followed by the name of the database. Like this:

\c my_database

After running this command, you'll see the following message:

You are now connected to database "my_database" as user "postgres".

This means that you're now connected to my_database and can start using it!

Conclusion​

Congratulations! You've just created your first database with PostgreSQL. From here, you can start creating tables, inserting data, and querying your database. Remember, practice makes perfect, so don't be afraid to experiment and try new things. Happy learning!