server.js

const express = require("express");
const app = express();
const Pool = require("pg").Pool;

const pool = new Pool({
  user: "postgres",
  database: "example",
  password: "postgres",
  host: "db",
  port:5555
});

pool.query(`CREATE TABLE users (
    ID SERIAL PRIMARY KEY,
    name VARCHAR(30),
    email VARCHAR(30)
)`);

app.get("/", async (req, res) => {
  await pool.query("INSERT INTO users (name, email) VALUES ('docker','this is cool')");
  const data = await pool.query("SELECT * FROM users;");
  res.send(data.rows);
});

app.listen(port, function () {
  console.log("Example app listening on port 8080! 🚀");
});