Drizzle TeamDT
Drizzle Teamā€¢3y ago
BabaYaga

drizzle-zod doesn't work with Array in pg

I'm using drizzle-orm, drizzle-kit & drizzle-zod in my application. One of my schema looks like following:

export const committee = pgTable("committee", {
  id: text("id").primaryKey().notNull(),
  safety_health: text("safety_health"),
  safety_health_sources: text(
    "safety_health_sources"
  ).array(),
  // other properties


The schema works fine when I push, safety_health_sources is created as an array (No issues till this point)

I create zod schema as well, like following:

export const committeeSchema = createSelectSchema(committee);

and when I do:

type Committee = Partial<
  z.infer<typeof committeeSchema>
>;
// the type become something like following
type Committee = {
    id?: string | undefined;
    safety_health?: string | null | undefined;
    safety_health_sources?: string | null | undefined; // <--- The problem is here, it should be an Array<string>
    // other properties
}
Was this page helpful?