setup.js

const { Pool } = require('pg');

const db = new Pool({
  connectionString: process.env.DATABASE_URL,
  ssl: true,
});

(async () => {
    try {
        await db.query("create table entries (createdat timestamp with time zone, text text)");
        await db.query("insert into entries values (now(), 'Today I started a new diary.')");
    } catch (e) {
        console.error(e);
    }
})();