Overview
PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language while Springboot is an open source, Java based framework that helps developers to setup spring applications on the fly by removing boilerplate code and configurations. Though there are several ways to connect to PostgreSQL database from a Springboot application, we are going to focus on JDBC template and how to perform CRUD operations using it in this article.
The sample program have been tested to run with the following software:
PostgreSQL 10 or above PgAdmin4(GUI tool of PostgreSQL) Eclipse