Postgres CRUD

In this post, we will look at, how we can perform CRUD operation on Postgres Database.

Assumptions:

1. vutil is installed.

2. Postgres connection is configured in the config.json file in vutil directory.

First create a test case which will fire a HTTP request on vutil server to validate the database state:

Open

CRUD Operations:

1. Insert Query
   Insert query can be specified as shown in the following screenshot:
    

   Open

   

2. Select Query
   Select query can be specified as shown in the following screenshot:
   
   

   Open

   

3. Update Query
   Update query can be specified as shown in the following screenshot: 
   
   

   Open

   

    

4. Delete Query
   Delete query can be specified as shown in the following screenshot:
   
   

   Open