从javascript中将postgres数组字段设置为null

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

const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 'your_port',
});

const updateArrayFieldToNull = async () => {
  try {
    const client = await pool.connect();
    const query = 'UPDATE your_table SET your_array_field = null WHERE your_condition';
    await client.query(query);
    client.release();
    console.log('Array field updated to null successfully');
  } catch (error) {
    console.error('Error updating array field:', error);
  } finally {
    pool.end();
  }
};

updateArrayFieldToNull();