Interface PostgresDialectConfig

A pg Client constructor, to be used for connecting to the database outside of the pool to avoid waiting for an idle connection.

This is useful for cancelling queries on the database side.

Defaults to the Pool's undocumented Client member, if it exists.

https://github.com/brianc/node-postgres/tree/master/packages/pg-cursor

import { PostgresDialect } from 'kysely'
import { Pool } from 'pg'
import Cursor from 'pg-cursor'
// or import * as Cursor from 'pg-cursor'

new PostgresDialect({
 cursor: Cursor,
 pool: new Pool('postgres://localhost:5432/mydb')
})
Copy

Called once for each created connection.

Called every time a connection is acquired from the pool.

A postgres Pool instance or a function that returns one.

If a function is provided, it's called once when the first query is executed.

https://node-postgres.com/apis/pool