© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•16mo ago•
1 reply
fstodulski

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
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:
Screenshot_2024-10-21_at_20.10.59.png
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

createInsertSchema & createSelectSchema difference
Drizzle TeamDTDrizzle Team / help
3y ago
Can't use `where` clause?
Drizzle TeamDTDrizzle Team / help
12mo ago
Defining types for default values in createSelectSchema
Drizzle TeamDTDrizzle Team / help
2y ago
Psql Array of text and `createSelectSchema`, `createInsertSchema`
Drizzle TeamDTDrizzle Team / help
3y ago