I have a table in postgres with some jsonb columns. create table example ( "id" serial, "name" text, "location" jsonb, "account_info" jsonb, "age" int ) I query a rest api to fetch the data to insert into the table. Example response from rest api call; [{ "id": 1, "name": "Jackson", …

It looks like you need to stringify it with JSON.stringify(query.data). You can alsocheck with JSON.parse(query.data) and seeing if JS returns an error.

Insert record to table with jsonb column

Insert record to table with jsonb column