import { kysely } from "https://deno.land/x/kysely_postgrs_js_dialect@v0.27.4/mod.ts";
const { CreateTableBuilder } = kysely;
This can be used to add any additional SQL to the front of the query after the create
keyword.
Also see temporary.
Examples
db.schema.createTable('person')
.modifyFront(sql`global temporary`)
.addColumn('id', 'integer', col => col.primaryKey())
.addColumn('first_name', 'varchar(64)', col => col.notNull())
.addColumn('last_name', 'varchar(64), col => col.notNull())
.execute()
The generated SQL (Postgres):
create global temporary table "person" (
"id" integer primary key,
"first_name" varchar(64) not null,
"last_name" varchar(64) not null
)
Parameters
modifier: Expression<any>
Returns
CreateTableBuilder<TB, C>