Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

156
Views
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.

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!