Loading and Querying the Database

Chinook database

We’ll be doing four tasks in this section.

1. Import the Chinook database in PostgreSQL using pgloader. First, we need to start the PostgreSQL service by using the following command:

Use the following command to run the upcoming commands as the PostgreSQL superuser.

Note: The Chinook database is already created for you.

2. Log in to the database. To use the psql, type the following command in the terminal:

Use the following command to log in to the Chinook database:

3. Now, that the dataset is loaded, list the relations in the Chinook database using the following command:

4. The next task is to see the details of any table in the Chinook database. We’ll see the details of the track table using the following command:

Click “Click to connect…” in the following terminal to start.

Tip: Press the up and down arrow keys to move between the rows and q to ...