Connecting to a PostgreSQL database instance

Here, we are using a PostgreSQL tool called pgAdmin 4, version 4.5, which was released in April 2019, to insert data for our ATM database. Download and install the pgAdmin 4 tool from https://www.pgadmin.org/download/pgadmin-4-windows/, and you should be able to view the main browser of pgAdmin 4.5, as follows:

Figure 2.15 – The pgAdmin 4.5 main browser

Next, we need to create a connection to the RDS before we can read and write data to the created ATM database.