Using "json_populate_recordset" in Postgre in fields other than json x table input

Asked

Viewed 21 times

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.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.