Create a Heroku Postgres Client in Node.js

1import { Client } from "pg";
2async function pgConnect() {
3  const DATABASE_URL = process.env.DATABASE_URL;
4  if (!DATABASE_URL) {
5    throw new Error("DATABASE_URL is not set");
6  }
7  // Connect to PostgreSQL
8  const client = new Client({
9    connectionString: DATABASE_URL,
10    ssl: {
11      rejectUnauthorized: false,
12    },
13  });
14
15  await client.connect();
16  return client;
17}