在nodejs中管理数据库的Postgres sql脚本

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

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

client.connect();

client.query('SELECT * FROM your_table', (err, res) => {
  if (err) {
    console.error(err);
  } else {
    console.log(res.rows);
  }
  client.end();
});

const insertQuery = 'INSERT INTO your_table (column1, column2) VALUES ($1, $2)';
const values = ['value1', 'value2'];

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

const updateQuery = 'UPDATE your_table SET column1 = $1 WHERE column2 = $2';
const values = ['new_value', 'condition_value'];

client.query(updateQuery, values, (err, res) => {
  if (err) {
    console.error(err);
  } else {
    console.log('Data updated successfully');
  }
  client.end();
});

const deleteQuery = 'DELETE FROM your_table WHERE column = $1';
const values = ['value'];

client.query(deleteQuery, values, (err, res) => {
  if (err) {
    console.error(err);
  } else {
    console.log('Data deleted successfully');
  }
  client.end();
});