Kysely•3y ago

how to insert an array of strings

hey guys,

I wanted to know how to store an array of strings with kysely, I created my table using migrations:

  await db.schema
    .withSchema("schemaName")
    .createTable("tableName")
    .addColumn("id", "bigserial", (col) => col.primaryKey())
    .addColumn("columnName", sql`text[]`)

  await db.schema
    .withSchema("schemaName")
    .createTable("tableName")
    .addColumn("id", "bigserial", (col) => col.primaryKey())
    .addColumn("columnName", sql`text[]`)

  await db.schema
    .withSchema("schemaName")
    .createTable("tableName")
    .addColumn("id", "bigserial", (col) => col.primaryKey())
    .addColumn("columnName", sql`text[]`)

  await db.schema
    .withSchema("schemaName")
    .createTable("tableName")
    .addColumn("id", "bigserial", (col) => col.primaryKey())
    .addColumn("columnName", sql`text[]`)

I ran it this way and it created the table, but the problem now is inserting the data:

  const insertedProductId: any = await db
     .insertInto("teleclinica.product")
     .values({
       columnName: ["data1", "data2"]
     })
     .returning(['id'])
     .executeTakeFirstOrThrow()

  const insertedProductId: any = await db
     .insertInto("teleclinica.product")
     .values({
       columnName: ["data1", "data2"]
     })
     .returning(['id'])
     .executeTakeFirstOrThrow()

  const insertedProductId: any = await db
     .insertInto("teleclinica.product")
     .values({
       columnName: ["data1", "data2"]
     })
     .returning(['id'])
     .executeTakeFirstOrThrow()

  const insertedProductId: any = await db
     .insertInto("teleclinica.product")
     .values({
       columnName: ["data1", "data2"]
     })
     .returning(['id'])
     .executeTakeFirstOrThrow()

I'm using postgresql, could you help me please

koskimas•8/8/23, 3:06 PM

What's the problem?

koskimas•8/8/23, 3:07 PM

What's the type of columnNamecolumnName in the table interface?

NilOP•8/8/23, 5:27 PM

@koskimas It is returning QueryCompilerError: Could not serialize value when I try to register

koskimas•8/8/23, 5:51 PM

Ok so you aren't using any of the built-in dialects. You need to open an issue in the 3rd party dislect's repo you're using. We have no control over those.

how to insert an array of strings

Similar Threads

Similar Threads

Similar Threads