Creating a test and production environment

In this chapter, we will return to using PostgreSQL for both the extraction and loading of data. The data pipeline will require a test and production environment, each of which will have a staging and a warehouse table. To create the databases and tables, you will use PgAdmin4.

Creating the databases

To use PgAdmin4, perform the following steps:

1. Browse to http://localhostw/pgadmin4/l, enter your username and password, and then click the Login button. Once logged in, expand the server icon in the left panel.
2. To create the databases, right-click on the databases icon and select Create | Database. Name the database test.
3. Next, you will need to add the tables. To create the staging table, right-click on Tables | Create | Table. On the General tab, name the table staging. Then, select the Columns tab. Using the plus sign, create the fields shown in the following screenshot:

   Figure 11.1 – The columns used in the staging...