class kysely.PostgresDialect
implements Dialect
import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.3/mod.ts";
const { PostgresDialect } = kysely;
PostgreSQL dialect that uses the pg library.
The constructor takes an instance of PostgresDialectConfig.
import { Pool } from 'pg'
new PostgresDialect({
pool: new Pool({
database: 'some_db',
host: 'localhost',
})
})
If you want the pool to only be created once it's first used, pool
can be a function:
import { Pool } from 'pg'
new PostgresDialect({
pool: async () => new Pool({
database: 'some_db',
host: 'localhost',
})
})
Constructors
new
PostgresDialect(config: PostgresDialectConfig)Methods
createIntrospector(db: Kysely<any>): DatabaseIntrospector
Creates a database introspector that can be used to get database metadata such as the table names and column names of those tables.
db
never has any plugins installed. It's created using
{@link Kysely.withoutPlugins}.