Loading the Sample Datasets – macOS

Most exercises in this book use a sample database, sqlda, which contains fabricated data for a fictional electric vehicle company called ZoomZoom. Now, set it up by performing the following steps:

1. Enter the PostgreSQL shell by typing the following command in Terminal. Press the return key to execute it:

   psql postgres

2. Now, create a new database called sqlda by typing the following command and pressing return (do not forget the semicolon at the end):

   create database sqlda;

3. You should see the following output. Type \l (a backslash followed by lowercase L) in Terminal and press the return key to check whether the database was successfully created (you should see the sqlda database listed there):

Figure 0.30: Checking whether a new database is successfully created

4. Type or paste \q in the PostgreSQL shell and press the return key to exit.
5. Download the data.dump file from the Datasets folder in the GitHub repository of this book at https://packt.link/GuU31. Navigate to the folder where you have downloaded the file using the cd command. Then, type the following command:

   psql sqlda < ~/Downloads/data.dump

   Note

   The preceding command assumes that the file is saved in the Downloads directory. Make sure you change the highlighted path based on the location of the data.dump file on your system.

6. Then, wait for the dataset to be imported:

Figure 0.31: Importing the dataset

7. To test if the dataset was imported correctly, type psql postgres and then press the return key to enter the PostgreSQL shell again. Then, run \c sqlda followed by \dt to see the list of tables within the database:

Figure 0.32: List of tables within the sqlda database