knexfile.ts

import type { Knex } from 'knex';
import dotenv from 'dotenv';

dotenv.config();

// Update with your config settings.

const config: { [key: string]: Knex.Config } = {
	development: {
		client: 'postgresql',
		connection: {
			database: process.env.DB_NAME,
			user: process.env.DB_USERNAME,
			password: process.env.DB_PASSWORD
		},
		pool: {
			min: 2,
			max: 10
		},
		debug: true,
		migrations: {
			tableName: 'knex_migrations'
		}
	},

    test:{
        client: 'postgresql',
        connection: {
			host: process.env.POSTGRES_HOST,
			database: process.env.POSTGRES_DB,
			user:     process.env.POSTGRES_USER,
			password: process.env.POSTGRES_PASSWORD
        },
        pool: {
            min: 2,
            max: 10
        },
        migrations: {
            tableName: 'knex_migrations'
        } 
    },

	production: {
		client: 'postgresql',
		connection: {
			database: process.env.DB_NAME,
			user:     process.env.DB_USERNAME,
			password: process.env.DB_PASSWORD
		},
		pool: {
			min: 2,
			max: 10
		},
		migrations: {
			tableName: 'knex_migrations'
		}
	}
};

module.exports = config;