DrizzleZod - Can't use "createSelectSchema"

Hi! I have an issue with drizzle-orm & drizzle-zod from the beginning of my turborepo project. Packages:

  
"dependencies": {
    "@paralleldrive/cuid2": "^2.2.2",
    "@t3-oss/env-core": "^0.11.1",
    "dotenv": "^16.4.5",
    "drizzle-orm": "^0.35.2",
    "drizzle-zod": "^0.5.1",
    "pg": "^8.13.0",
    "zod": "^3.23.8"
  },
  "devDependencies": {
    "@types/pg": "^8.11.10",
    "drizzle-kit": "^0.26.2",
    "tsx": "^4.19.1"
  }

  
"dependencies": {
    "@paralleldrive/cuid2": "^2.2.2",
    "@t3-oss/env-core": "^0.11.1",
    "dotenv": "^16.4.5",
    "drizzle-orm": "^0.35.2",
    "drizzle-zod": "^0.5.1",
    "pg": "^8.13.0",
    "zod": "^3.23.8"
  },
  "devDependencies": {
    "@types/pg": "^8.11.10",
    "drizzle-kit": "^0.26.2",
    "tsx": "^4.19.1"
  }

Simple Users table Definition:

import { createId } from "@paralleldrive/cuid2";

import { pgTable, text, timestamp } from "drizzle-orm/pg-core";
import { timestampColumns } from "src/schema/_shared/time-stamp";

import { createSelectSchema } from "drizzle-zod";

export const TB_Users = pgTable("users", {
  id: text("id").primaryKey().$defaultFn(createId),

  email: text("email").unique().notNull(),
  passwordHash: text("password_hash").notNull(),
  emailVerified: timestamp("email_verified", { mode: "date" }).notNull(),

  ...timestampColumns,
});

export const userSchema = createSelectSchema(TB_Users);

import { createId } from "@paralleldrive/cuid2";

import { pgTable, text, timestamp } from "drizzle-orm/pg-core";
import { timestampColumns } from "src/schema/_shared/time-stamp";

import { createSelectSchema } from "drizzle-zod";

export const TB_Users = pgTable("users", {
  id: text("id").primaryKey().$defaultFn(createId),

  email: text("email").unique().notNull(),
  passwordHash: text("password_hash").notNull(),
  emailVerified: timestamp("email_verified", { mode: "date" }).notNull(),

  ...timestampColumns,
});

export const userSchema = createSelectSchema(TB_Users);

Getting Error for userSchema:

1 Reply

franek.stodulski•18h ago

Also. For drizzle db instance. Following these steps "https://orm.drizzle.team/docs/get-started-postgresql#step-1---install-packages"

import { drizzle } from "drizzle-orm/node-postgres";

import { DATABASE_URL } from "./env";

export const db = drizzle(DATABASE_URL);

import { drizzle } from "drizzle-orm/node-postgres";

import { DATABASE_URL } from "./env";

export const db = drizzle(DATABASE_URL);

Drizzle ORM - PostgreSQL

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Gaming

Programming

DrizzleZod - Can't use "createSelectSchema"