12345678910111213141516171819202122232425262728293031 |
- const { Client } = require('pg')
- const client = new Client({
- user: 'postgres',
- host: 'localhost',
- database: 'testdb',
- password: '1234abcd',
- port: 5432,
- });
- client.connect()
- const query = `
- UPDATE users
- SET age = 22
- WHERE email = 'johndoe@gmail.com'
- `
- client.query(query, (err, res) => {
- if (err) {
- console.error(err);
- return;
- }
- if (err) {
- console.error(err);
- return;
- }
- console.log('Data update successful');
- });
|