'Insert JSON data into PostgreSQL database via knex.js with different object key names and column names
I'm not sure where to start cause knex docs only show how to insert object data with the same column name and key cases. The problem is I have this example database table:
CREATE TABLE IF NOT EXISTS student_info (
id SERIAL PRIMARY KEY,
full_name varchar(32),
);
and I have this example JSON to be inserted into that table:
[
{
id: 1,
name: 'John Doe'
},
{
id: 2,
name: 'Lita Wong'
}
]
There's a problem where full_name column and name key have different name. How can I insert that JSON data into my table without changing my key? I wish there's some way to set an alias or something, but I can't find it anywhere in docs.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
