delete-data.js 481 B

123456789101112131415161718192021222324252627282930
  1. const { Client } = require('pg')
  2. const client = new Client({
  3. user: 'postgres',
  4. host: 'localhost',
  5. database: 'testdb',
  6. password: '1234abcd',
  7. port: 5432,
  8. });
  9. client.connect()
  10. const query = `
  11. DELETE FROM users
  12. WHERE email = 'johndoe@gmail.com'
  13. `
  14. client.query(query, (err, res) => {
  15. if (err) {
  16. console.error(err);
  17. return;
  18. }
  19. if (err) {
  20. console.error(err);
  21. return;
  22. }
  23. console.log('Data delete successful');
  24. });