Module

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

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

Adds a column to the index.

Also see {@link columns} for adding multiple columns at once or {@link expression} for specifying an arbitrary expression.

Examples

await db.schema
        .createIndex('person_first_name_and_age_index')
        .on('person')
        .column('first_name')
        .column('age desc')
        .execute()

The generated SQL (PostgreSQL):

create index "person_first_name_and_age_index" on "person" ("first_name", "age" desc)

Type Parameters

CL extends string

Parameters

column: OrderedColumnName<CL>

Returns

CreateIndexBuilder<C | ExtractColumnNameFromOrderedColumnName<CL>>