The ATM locations table

The pgAdmin tool offers a graphical user interface to create a table, so we are going to use that user interface instead of DDL statements: 

1. We will create the ATM locations table inside the ATM RDS. For this, we need to right-click on the Tables entry on the left-hand side. Then, click on Create and select Table..., as shown in the following screenshot:

Figure 2.20 – Creating a table with pgAdmin

2. Within the following Create - Table dialog box, enter ATM locations inside the Name section:

Figure 2.21 – The Create - Table dialog box

3. Select the Columns tab, and then use the add new row (Shift + Ctrl + A) button (+) on the right-hand side to add all the table columns, as shown in the following screenshot. Then, click on Save:

Figure 2.22 – Creating columns for the ATM locations table

4. After the ATM locations table has been created, select the Tools menu and then select&...