How to insert nested JSON into PostgreSQL
CREATE TABLE Log ( "Name" TEXT, "Age" TEXT, "Country" TEXT, "Numbers" TEXT ); SELECT "Country", "Numbers" FROM json_populate_record( null:: log, '{ "Name": "qazwsx", "HostName": "Age", "Address": { "Country": "MNB", "Numbers": [ { "Cell": 7418520 } ] } }'); SELECT *…