Setting up pgTAP for PostgreSQL RDS

We'll set up pgTAP using the following RDS:

1. Use pgAdmin to connect to our ATM RDS on AWS and select the ATM database to set up pgTAP.
2. Then, navigate to the top menu bar, go to Tools | Query Tool, and then execute the following SQL statements by pressing the  icon on the toolbar, as in the following figure, Figure 11.1:

CREATE SCHEMA IF NOT EXISTS pgTAP;
CREATE EXTENSION IF NOT EXISTS pgTAP WITH SCHEMA pgTAP;

This is better illustrated here:

Figure 11.1 – pgTAP installation for AWS RDS

3. After that, you should be able to see the new pgTAP schema and the pgTAP stored procedures, as you can see in the preceding figure.