如何使用Node JS将JSON数据转换为表并存储到Postgres DB中？

const { Client } = require('pg');

const client = new Client({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 5432, // 默认PostgreSQL端口号为5432
});

client.connect();

const jsonData = '{"name": "John", "age": 30, "city": "New York"}';
const data = JSON.parse(jsonData);

let columns = '';
let values = '';

for (const key in data) {
  columns += `${key},`;
  values += `'${data[key]}',`;
}

columns = columns.slice(0, -1); // 去除最后一个逗号
values = values.slice(0, -1); // 去除最后一个逗号

const insertQuery = `INSERT INTO your_table (${columns}) VALUES (${values})`;

client.query(insertQuery, (err, res) => {
  if (err) {
    console.error(err);
  } else {
    console.log('Data inserted successfully');
  }

  client.end();
});