Module

x/kysely_postgrs_js_dialect/mod.ts>kysely.CreateIndexBuilder#expression

Kysely dialect for PostgreSQL using the Postgres.js client.
Byzanteam/kysely_postgres_js_dialect
Latest
method kysely.CreateIndexBuilder.prototype.expression
import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/mod.ts";
const { CreateIndexBuilder } = kysely;

Specifies an arbitrary expression for the index.

Examples

import { sql } from 'kysely'

await db.schema
  .createIndex('person_first_name_index')
  .on('person')
  .expression(sql`first_name COLLATE "fi_FI"`)
  .execute()

The generated SQL (PostgreSQL):

create index "person_first_name_index" on "person" (first_name COLLATE "fi_FI")

Parameters

expression: Expression<any>