Adapting Knex Configuration from SQLite to PostgreSQL

I'm facing an issue when trying to deploy a Node.js API that uses Knex, Express, and the SQLite database on Vercel. Since Vercel doesn't support SQLite, I'm seeking guidance on how to transform my project from using SQLite to PostgreSQL, which is supported by Vercel.

I'm following the Vercel guide for PostgreSQL: Vercel PostgreSQL Quickstart.

Here's my current knexfile.js file, which configures Knex to use SQLite:

const path = require('path');

module.exports = {
  development: {
    client: 'sqlite3',
    connection: {
      filename: path.resolve(__dirname, 'src', 'database', 'database.db'),
    },
    pool: {
      afterCreate: (conn, cb) => conn.run('PRAGMA foreign_keys = ON', cb),
    },
    migrations: {
      directory: path.resolve(
        __dirname,
        'src',
        'database',
        'knex',
        'migrations'
      ),
    },
    useNullAsDefault: true,
  },
};

I've already tried to change it to:

const path = require('path');

module.exports = {
  development: {
    client: 'pg',
    connection: {
      host: process.env.POSTGRES_HOST,
      user: process.env.POSTGRES_USER,
      password: process.env.POSTGRES_PASSWORD,
      database: process.env.POSTGRES_DATABASE,
      ssl: { rejectUnauthorized: false },
    },
    pool: {
      afterCreate: (conn, cb) => conn.run('PRAGMA foreign_keys = ON', cb),
    },
    migrations: {
      directory: path.resolve(
        __dirname,
        'src',
        'database',
        'knex',
        'migrations'
      ),
    },
    useNullAsDefault: true,
  },
};

But I only get errors, such as TypeError: conn.run is not a function at afterCreate (/var/task/knexfile.js:14:39).