I have an API that gives json data text file called corporateHoliday.txt.
The data look like this:
{
"holiday_id":"1712010100000104",
"holiday_date":"2018-12-30 00:00:00.0",
"holiday_description":"SUNDAY",
"holiday_status":"A"
},
{
"holiday_id":"1712010100000103",
"holiday_date":"2018-12-29 00:00:00.0",
"holiday_description":"SATURDAY",
"holiday_status":"A"
}
My postgres table attributes look like this t_leave_holida(objectid, holiday_date,description,recstatus)
I want to import these json data from txt file into the postgres database table?