EN
Node.js - PostgreSQL Drop database
0 points
In this article, we would like to show you how to drop a Postgres database in Node.js.
xxxxxxxxxx1
const { Client } = require('pg');2
3
const client = new Client({4
host: '127.0.0.1',5
user: 'postgres',6
database: 'database_name',7
password: 'password',8
port: 5432,9
});10
11
const execute = async (query) => {12
try {13
await client.connect(); // gets connection14
await client.query(query); // sends queries15
return true;16
} catch (error) {17
console.error(error.stack);18
return false;19
} finally {20
await client.end(); // closes connection21
}22
};23
24
execute('DROP DATABASE example_db').then(result => {25
if (result) {26
console.log('Database removed');27
}28
});