database.js

const pg = require('pg');
var pgtools = require('pgtools');


pgtools.createdb({
user: 'postgres',
host: '127.0.0.1',
password: '123',
port: '5432'},
'machines', function (err, res) {
  if (err) {
    console.error(err);
    process.exit(-1);
  }
  console.log(res);
}

);

// pool.query("CREATE TABLE machine(numeroSerie SERIAL PRIMARY KEY )", (err, res) => {
// console.log(err, res);
// pool.end();
// });

// , localizacao point NOT NULL,
// ala VARCHAR(40) NOT NULL, estado VARCHAR(40), manutencao DATE

// pool.query("SELECT PacienteRegistro FROM Paciente", (err, res) => {
// console.log(err, res);
// pool.end();
// });