0
I have a proc where you have to input the JSON file and insert it into a temp table(_test).
resultTeste := (select dados ->'Documento'->'Apolice' from _teste as result);
INSERT INTO _testeDados select * from json_populate_recordset(null::_testeDados,resultTeste);
Where the Insert table contains the columns: name, age and json contains: [{"Name": "Test", "Age": 23}]
However I can not enter because of the name of the value "Name"(uppercase) is different from the table "name" (minuscula) When changing the table name using Alter table and changing to "Name" equals Json, the value is inserted, but I cannot change the column name.
What could be done? NOTE: I CANNOT CHANGE THE TABLE.