kysely.CreateTableBuilder | /deps.ts | kysely_postgrs_js_dialect@v0.27.3

method kysely.CreateTableBuilder.prototype.as

import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.3/deps.ts";
const { CreateTableBuilder } = kysely;

as(expression: Expression<unknown>): CreateTableBuilder<string, never>

Allows to create table from select query.

db.schema.createTable('copy')
  .temporary()
  .as(db.selectFrom('person').select(['first_name', 'last_name']))
  .execute()

The generated SQL (PostgreSQL):

create temporary table "copy" as
select "first_name", "last_name" from "person"

Parameters

expression: Expression<unknown>