EN
Node.js - PostgreSQL Create database
0
points
In this article, we would like to show you how to create a PostgreSQL database in Node.js.
async/await example
const { Client } = require('pg');
const client = new Client({
host: '127.0.0.1',
user: 'postgres',
password: 'password',
port: 5432,
});
const createDatabase = async () => {
try {
await client.connect(); // gets connection
await client.query('CREATE DATABASE my_database'); // sends queries
return true;
} catch (error) {
console.error(error.stack);
return false;
} finally {
await client.end(); // closes connection
}
};
createDatabase().then((result) => {
if (result) {
console.log('Database created');
}
});